/*
 Navicat Premium Data Transfer

 Source Server         : localshot
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost
 Source Database       : jsh_erp

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : utf-8

 Date: 03/28/2023 22:53:29 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `jsh_account`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_account`;
CREATE TABLE `jsh_account` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `serial_no` varchar(50) DEFAULT NULL COMMENT '编号',
  `initial_amount` decimal(24,6) DEFAULT NULL COMMENT '期初金额',
  `current_amount` decimal(24,6) DEFAULT NULL COMMENT '当前余额',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `is_default` bit(1) DEFAULT NULL COMMENT '是否默认',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='账户信息';

-- ----------------------------
--  Records of `jsh_account`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_account` VALUES ('17', '账户1', 'A1', '99999999999999.000000', '99999999998890.000000', '', b'1', null, b'1', '63', '0'), ('18', '账户2', 'A2', '200.000000', '200.000000', 'bbbb', b'1', null, b'0', '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_account_head`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_account_head`;
CREATE TABLE `jsh_account_head` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类型(支出/收入/收款/付款/转账)',
  `organ_id` bigint(20) DEFAULT NULL COMMENT '单位Id(收款/付款单位)',
  `hands_person_id` bigint(20) DEFAULT NULL COMMENT '经手人id',
  `creator` bigint(20) DEFAULT NULL COMMENT '操作员',
  `change_amount` decimal(24,6) DEFAULT NULL COMMENT '变动金额(优惠/收款/付款/实付)',
  `discount_money` decimal(24,6) DEFAULT NULL COMMENT '优惠金额',
  `total_price` decimal(24,6) DEFAULT NULL COMMENT '合计金额',
  `account_id` bigint(20) DEFAULT NULL COMMENT '账户(收款/付款)',
  `bill_no` varchar(50) DEFAULT NULL COMMENT '单据编号',
  `bill_time` datetime DEFAULT NULL COMMENT '单据日期',
  `remark` varchar(1000) DEFAULT NULL COMMENT '备注',
  `file_name` varchar(500) DEFAULT NULL COMMENT '附件名称',
  `status` varchar(1) DEFAULT NULL COMMENT '状态，0未审核、1已审核、9审核中',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK9F4C0D8DB610FC06` (`organ_id`),
  KEY `FK9F4C0D8DAAE50527` (`account_id`),
  KEY `FK9F4C0D8DC4170B37` (`hands_person_id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='财务主表';

-- ----------------------------
--  Records of `jsh_account_head`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_account_head` VALUES ('118', '收入', '58', '16', '63', '55.000000', null, '55.000000', '17', 'SR00000000643', '2021-06-02 00:24:49', null, null, '0', '63', '1'), ('119', '支出', '68', '16', '63', '-66.000000', null, '-66.000000', '17', 'ZC00000000644', '2021-06-02 00:25:01', null, null, '0', '63', '1'), ('122', '转账', null, '17', '63', '-11.000000', null, '-11.000000', '17', 'ZZ00000000647', '2021-06-02 00:25:32', null, null, '0', '63', '1'), ('124', '收预付款', '60', '17', '63', '80.000000', '0.000000', '80.000000', null, 'SYF00000000649', '2021-07-06 23:43:48', null, null, '0', '63', '1'), ('125', '收款', '58', '17', '63', '10.000000', '0.000000', '10.000000', '17', 'SK00000000653', '2021-07-06 23:46:38', null, null, '0', '63', '1'), ('126', '付款', '57', '17', '63', '-50.000000', '0.000000', '-50.000000', '17', 'FK00000000654', '2021-07-06 23:47:23', null, null, '0', '63', '1');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_account_item`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_account_item`;
CREATE TABLE `jsh_account_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `header_id` bigint(20) NOT NULL COMMENT '表头Id',
  `account_id` bigint(20) DEFAULT NULL COMMENT '账户Id',
  `in_out_item_id` bigint(20) DEFAULT NULL COMMENT '收支项目Id',
  `bill_id` bigint(20) DEFAULT NULL COMMENT '单据id',
  `need_debt` decimal(24,6) DEFAULT NULL COMMENT '应收欠款',
  `finish_debt` decimal(24,6) DEFAULT NULL COMMENT '已收欠款',
  `each_amount` decimal(24,6) DEFAULT NULL COMMENT '单项金额',
  `remark` varchar(100) DEFAULT NULL COMMENT '单据备注',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK9F4CBAC0AAE50527` (`account_id`),
  KEY `FK9F4CBAC0C5FE6007` (`header_id`),
  KEY `FK9F4CBAC0D203EDC5` (`in_out_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 COMMENT='财务子表';

-- ----------------------------
--  Records of `jsh_account_item`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_account_item` VALUES ('143', '118', null, '23', null, null, null, '55.000000', '', '63', '1'), ('144', '119', null, '21', null, null, null, '66.000000', '', '63', '1'), ('147', '122', '17', null, null, null, null, '11.000000', '', '63', '1'), ('149', '124', '17', null, null, null, null, '80.000000', '', '63', '1'), ('150', '125', null, null, '272', '20.000000', '0.000000', '10.000000', '', '63', '1'), ('151', '126', null, null, '271', '60.000000', '0.000000', '-50.000000', '', '63', '1');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_bom`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_bom`;
CREATE TABLE `jsh_bom` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `standard` varchar(50) DEFAULT NULL,
  `model` varchar(50) DEFAULT NULL,
  `material_id` bigint(20) DEFAULT NULL,
  `bar_code` varchar(50) DEFAULT NULL,
  `tenant_id` bigint(20) DEFAULT NULL,
  `delete_flag` varchar(1) DEFAULT '0',
  `unit` varchar(20) DEFAULT NULL,
  `category_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `jsh_bom`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_bom` VALUES ('10', '23', '太阳花', null, null, '624', '1028', '63', '1', '个', '成品'), ('11', '23', '太阳花', null, null, '624', '1028', '63', '1', '个', '成品'), ('12', '23', '太阳花', null, null, '624', '1027', '63', '1', '个', '成品'), ('16', '23', '太阳花', null, null, '624', '1027', '63', '1', '个', '成品'), ('18', '23', '太阳花', null, null, '624', '1027', '63', '1', '个', '成品'), ('19', '23', '太阳花', null, null, '624', '1027', '63', '1', '个', '成品'), ('20', '23', '太阳花', '1.5KW', 'T1', '625', '1024', '63', '1', '个', '成品'), ('21', '23', '太阳花', '1.5KW', 'T1', '625', '1024', '63', '1', '个', '成品'), ('22', '23', '太阳花', '1.5KW', 'T1', '625', '1024', '63', '0', '个', '成品');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_bom_material`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_bom_material`;
CREATE TABLE `jsh_bom_material` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `material_id` bigint(20) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `bar_code` varchar(50) DEFAULT NULL,
  `category_id` bigint(20) DEFAULT NULL,
  `bom_id` bigint(20) DEFAULT NULL,
  `bom_name` varchar(100) DEFAULT NULL,
  `count` bigint(20) DEFAULT NULL,
  `tenant_id` bigint(20) DEFAULT NULL,
  `delete_flag` varchar(1) DEFAULT '0',
  `category_name` varchar(50) DEFAULT NULL,
  `unit` varchar(20) DEFAULT NULL,
  `standard` varchar(50) DEFAULT NULL,
  `model` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1635637832164479007 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `jsh_bom_material`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_bom_material` VALUES ('1635637832164478987', '623', '支架', '1023', '17', '10', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164478988', '622', '电池', '1022', '17', '10', '太阳花', '10', '63', '1', '原料', '个'), ('1635637832164478989', '623', '支架', '1023', '17', '20', '太阳花', '3', '63', '1', '原料', '个'), ('1635637832164478990', '624', '太阳花', '1027', '23', '12', '太阳花', '1', '63', '1', '成品', '个'), ('1635637832164478991', '623', '支架', '1023', '17', '16', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164478992', '622', '电池', '1022', '17', '16', '太阳花', '10', '63', '1', '原料', '个'), ('1635637832164478993', '623', '支架', '1023', '17', '18', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164478994', '622', '电池', '1022', '17', '18', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164478995', '623', '支架', '1023', '17', '19', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164478996', '622', '电池', '1022', '17', '19', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164478997', '623', '支架', '1023', '17', '12', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164478998', '622', '电池', '1022', '17', '12', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164478999', '622', '电池', '1022', '17', '12', '太阳花', '1', '63', '1', '原料', '个'), ('1635637832164479000', '622', '电池', '1022', '17', '20', '太阳花', '2', '63', '1', '原料', '个'), ('1635637832164479001', '623', '支架', '1023', '17', '21', '太阳花', '3', '63', '1', '原料', '个'), ('1635637832164479002', '622', '电池', '1022', '17', '21', '太阳花', '2', '63', '1', '原料', '个'), ('1635637832164479003', '623', '支架', '1023', '17', '22', '太阳花', '3', '63', '1', '原料', '个'), ('1635637832164479004', '622', '电池', '1022', '17', '22', '太阳花', '2', '63', '1', '原料', '个'), ('1635637832164479005', '623', '支架', '1023', '17', '22', '太阳花', '2', '63', '0', '原料', '个'), ('1635637832164479006', '622', '电池', '1022', '17', '22', '太阳花', '1', '63', '0', '原料', '个');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_depot`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_depot`;
CREATE TABLE `jsh_depot` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) DEFAULT NULL COMMENT '仓库名称',
  `address` varchar(50) DEFAULT NULL COMMENT '仓库地址',
  `warehousing` decimal(24,6) DEFAULT NULL COMMENT '仓储费',
  `truckage` decimal(24,6) DEFAULT NULL COMMENT '搬运费',
  `type` int(10) DEFAULT NULL COMMENT '类型',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `remark` varchar(100) DEFAULT NULL COMMENT '描述',
  `principal` bigint(20) DEFAULT NULL COMMENT '负责人',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_Flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `is_default` bit(1) DEFAULT NULL COMMENT '是否默认',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='仓库表';

-- ----------------------------
--  Records of `jsh_depot`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_depot` VALUES ('14', '仓库1', 'dizhi', '12.000000', '12.000000', '0', '1', '描述', '131', b'1', '63', '0', b'1'), ('15', '仓库2', '地址100', '555.000000', '666.000000', '0', '2', 'dfdf', '131', b'1', '63', '0', b'0'), ('17', '仓库3', '123123', '123.000000', '123.000000', '0', '3', '123', '131', b'1', '63', '0', b'0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_depot_head`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_depot_head`;
CREATE TABLE `jsh_depot_head` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类型(出库/入库)',
  `sub_type` varchar(50) DEFAULT NULL COMMENT '出入库分类',
  `default_number` varchar(50) DEFAULT NULL COMMENT '初始票据号',
  `number` varchar(50) DEFAULT NULL COMMENT '票据号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `oper_time` datetime DEFAULT NULL COMMENT '出入库时间',
  `organ_id` bigint(20) DEFAULT NULL COMMENT '供应商id',
  `creator` bigint(20) DEFAULT NULL COMMENT '操作员',
  `account_id` bigint(20) DEFAULT NULL COMMENT '账户id',
  `change_amount` decimal(24,6) DEFAULT NULL COMMENT '变动金额(收款/付款)',
  `back_amount` decimal(24,6) DEFAULT NULL COMMENT '找零金额',
  `total_price` decimal(24,6) DEFAULT NULL COMMENT '合计金额',
  `pay_type` varchar(50) DEFAULT NULL COMMENT '付款类型(现金、记账等)',
  `bill_type` varchar(50) DEFAULT NULL COMMENT '单据类型',
  `remark` varchar(1000) DEFAULT NULL COMMENT '备注',
  `file_name` varchar(500) DEFAULT NULL COMMENT '附件名称',
  `sales_man` varchar(50) DEFAULT NULL COMMENT '业务员（可以多个）',
  `account_id_list` varchar(50) DEFAULT NULL COMMENT '多账户ID列表',
  `account_money_list` varchar(200) DEFAULT NULL COMMENT '多账户金额列表',
  `discount` decimal(24,6) DEFAULT NULL COMMENT '优惠率',
  `discount_money` decimal(24,6) DEFAULT NULL COMMENT '优惠金额',
  `discount_last_money` decimal(24,6) DEFAULT NULL COMMENT '优惠后金额',
  `other_money` decimal(24,6) DEFAULT NULL COMMENT '销售或采购费用合计',
  `deposit` decimal(24,6) DEFAULT NULL COMMENT '订金',
  `status` varchar(1) DEFAULT NULL COMMENT '状态，0未审核、1已审核、2完成采购|销售、3部分采购|销售',
  `purchase_status` varchar(1) DEFAULT NULL COMMENT '采购状态，0未采购、2完成采购、3部分采购',
  `link_number` varchar(50) DEFAULT NULL COMMENT '关联订单号',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `LinkNumber` varchar(50) DEFAULT NULL COMMENT '关联订单号',
  PRIMARY KEY (`id`),
  KEY `FK2A80F214B610FC06` (`organ_id`),
  KEY `FK2A80F214AAE50527` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=304 DEFAULT CHARSET=utf8 COMMENT='单据主表';

-- ----------------------------
--  Records of `jsh_depot_head`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_depot_head` VALUES ('258', '其它', '采购订单', 'CGDD00000000630', 'CGDD00000000630', '2021-06-02 00:21:54', '2021-06-02 00:21:44', '57', '63', null, null, null, '-110.000000', '现付', null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('259', '入库', '采购', 'CGRK00000000631', 'CGRK00000000631', '2021-06-02 00:22:23', '2021-06-02 00:22:05', '57', '63', '17', '-110.000000', null, '-110.000000', '现付', null, null, null, null, '', '', '0.000000', '0.000000', '110.000000', '0.000000', null, '0', '0', 'CGDD00000000630', '63', '1', null), ('260', '出库', '采购退货', 'CGTH00000000632', 'CGTH00000000632', '2021-06-02 00:22:35', '2021-06-02 00:22:26', '57', '63', '17', '22.000000', null, '22.000000', '现付', null, null, null, null, null, null, '0.000000', '0.000000', '22.000000', '0.000000', null, '0', '0', null, '63', '1', null), ('261', '其它', '销售订单', 'XSDD00000000633', 'XSDD00000000633', '2021-06-02 00:22:48', '2021-06-02 00:22:39', '58', '63', null, null, null, '44.000000', '现付', null, null, null, '', null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('262', '出库', '销售', 'XSCK00000000634', 'XSCK00000000634', '2021-06-02 00:23:03', '2021-06-02 00:22:54', '58', '63', '17', '44.000000', null, '44.000000', '现付', null, null, null, '', '', '', '0.000000', '0.000000', '44.000000', '0.000000', null, '0', '0', 'XSDD00000000633', '63', '1', null), ('263', '入库', '销售退货', 'XSTH00000000635', 'XSTH00000000635', '2021-06-02 00:23:12', '2021-06-02 00:23:05', '71', '63', '17', '-22.000000', null, '-22.000000', '现付', null, null, null, '', '', '', '0.000000', '0.000000', '22.000000', '0.000000', null, '0', '0', null, '63', '1', null), ('264', '出库', '零售', 'LSCK00000000636', 'LSCK00000000636', '2021-06-02 00:23:21', '2021-06-02 00:23:14', '60', '63', '17', '22.000000', null, '22.000000', '现付', null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('265', '入库', '零售退货', 'LSTH00000000637', 'LSTH00000000637', '2021-06-02 00:23:29', '2021-06-02 00:23:23', '60', '63', '17', '-22.000000', null, '-22.000000', '现付', null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('266', '入库', '其它', 'QTRK00000000638', 'QTRK00000000638', '2021-06-02 00:23:48', '2021-06-02 00:23:36', '57', '63', null, null, null, '-55.000000', '现付', null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('267', '出库', '其它', 'QTCK00000000639', 'QTCK00000000639', '2021-06-02 00:23:59', '2021-06-02 00:23:50', '58', '63', null, null, null, '30.000000', '现付', null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('268', '出库', '调拨', 'DBCK00000000640', 'DBCK00000000640', '2021-06-02 00:24:09', '2021-06-02 00:24:00', null, '63', null, null, null, '11.000000', '现付', null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('269', '其它', '组装单', 'ZZD00000000641', 'ZZD00000000641', '2021-06-02 00:24:29', '2021-06-02 00:24:11', null, '63', null, null, null, '0.000000', '现付', null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('270', '其它', '拆卸单', 'CXD00000000642', 'CXD00000000642', '2021-06-02 00:24:45', '2021-06-02 00:24:32', null, '63', null, null, null, '0.000000', '现付', null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, '63', '1', null), ('271', '入库', '采购', 'CGRK00000000651', 'CGRK00000000651', '2021-07-06 23:45:20', '2021-07-06 23:44:45', '57', '63', '17', '-20.000000', null, '-80.000000', '现付', null, null, null, null, '', '', '0.000000', '0.000000', '80.000000', '0.000000', null, '0', '0', null, '63', '1', null), ('272', '出库', '销售', 'XSCK00000000652', 'XSCK00000000652', '2021-07-06 23:46:07', '2021-07-06 23:45:24', '58', '63', '17', '8.000000', null, '28.000000', '现付', null, null, null, '', '', '', '0.000000', '0.000000', '28.000000', '0.000000', null, '0', '0', null, '63', '1', null), ('273', '入库', '采购', 'CGRK00000000658', 'CGRK00000000658', '2021-07-28 00:58:12', '2021-07-28 00:58:02', '57', '63', '17', '-60.000000', null, '-60.000000', '现付', null, null, null, null, '', '', '0.000000', '0.000000', '60.000000', '0.000000', null, '0', '0', null, '63', '1', null), ('274', '其它', '采购订单', 'CGDD00000000666', 'CGDD00000000666', '2023-03-06 18:08:37', '2023-03-06 18:06:46', '74', '63', '17', '0.000000', null, '0.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '0.000000', null, null, '0', '0', null, '63', '1', null), ('275', '入库', '采购', 'CGRK00000000667', 'CGRK00000000667', '2023-03-06 18:10:10', '2023-03-06 18:08:53', '74', '63', '17', '0.000000', null, '0.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '0.000000', '0.000000', null, '0', '0', 'CGDD00000000666', '63', '1', null), ('276', '其它', '采购订单', 'CGDD00000000669', 'CGDD00000000669', '2023-03-06 21:25:01', '2023-03-06 21:23:16', '74', '63', '17', '-1000.000000', null, '0.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '0.000000', null, null, '0', '0', null, '63', '1', null), ('277', '入库', '采购', 'CGRK00000000675', 'CGRK00000000675', '2023-03-06 21:30:44', '2023-03-06 21:29:38', '74', '63', '17', '0.000000', null, '0.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '0', '0', 'CGDD00000000669', '63', '1', null), ('278', '其它', '采购订单', 'CGDD00000000678', 'CGDD00000000678', '2023-03-06 22:04:17', '2023-03-06 22:03:48', '74', '63', '17', '0.000000', null, '-400.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '400.000000', null, null, '0', '0', null, '63', '1', null), ('279', '入库', '采购', 'CGRK00000000679', 'CGRK00000000679', '2023-03-06 22:06:46', '2023-03-06 22:06:27', '74', '63', '17', '-400.000000', null, '-400.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '400.000000', '0.000000', null, '0', '0', 'CGDD00000000678', '63', '1', null), ('280', '出库', '采购退货', 'CGTH00000000680', 'CGTH00000000680', '2023-03-06 22:07:45', '2023-03-06 22:07:10', '74', '63', '17', '10.000000', null, '10.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '10.000000', '0.000000', null, '0', '0', 'CGRK00000000675', '63', '1', null), ('281', '其它', '组装单', 'ZZD00000000693', 'ZZD00000000693', '2023-03-09 21:57:43', '2023-03-09 21:56:49', null, '63', null, null, null, '2.000000', '现付', null, null, '', null, null, null, null, null, null, null, null, '1', '0', null, '63', '0', null), ('282', '其它', '拆卸单', 'CXD00000000695', 'CXD00000000695', '2023-03-09 21:59:35', '2023-03-09 21:59:08', null, '63', null, null, null, '2.000000', '现付', null, null, '', null, null, null, null, null, null, null, null, '1', '0', null, '63', '0', null), ('283', '入库', '其它', 'QTRK00000000697', 'QTRK00000000697', '2023-03-09 22:03:40', '2023-03-09 22:03:09', '57', '63', null, null, null, '-200.000000', '现付', null, '初始化库存', '', null, null, null, null, null, null, null, null, '1', '0', null, '63', '0', null), ('284', '其它', '采购订单', 'CGDD00000000700', 'CGDD00000000700', '2023-03-09 22:08:53', '2023-03-09 22:08:15', '57', '63', '17', '0.000000', null, '-11.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '11.000000', null, null, '3', '0', null, '63', '0', null), ('285', '入库', '采购', 'CGRK00000000701', 'CGRK00000000701', '2023-03-09 22:10:50', '2023-03-09 22:09:01', '57', '63', '17', '-5.000000', null, '-5.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '5.000000', '0.000000', null, '1', '0', 'CGDD00000000700', '63', '0', null), ('286', '其它', '组装单', 'ZZD00000000699', 'ZZD00000000699', '2023-03-09 22:12:47', '2023-03-09 22:08:11', null, '63', null, null, null, '2.000000', '现付', null, null, '', null, null, null, null, null, null, null, null, '1', '0', null, '63', '0', null), ('287', '其它', '组装单', 'ZZD00000000767', 'ZZD00000000767', '2023-03-16 21:14:23', '2023-03-16 21:14:00', null, '63', null, null, null, '0.000000', '现付', null, null, '', null, null, null, null, null, null, null, null, '1', '0', null, '63', '0', null), ('288', '其它', '拆卸单', 'CXD00000000771', 'CXD00000000771', '2023-03-16 21:21:45', '2023-03-16 21:21:14', null, '63', null, null, null, '0.000000', '现付', null, null, '', null, null, null, null, null, null, null, null, '1', '0', null, '63', '0', null), ('289', '其它', '采购订单', 'CGDD00000000782', 'CGDD00000000782', '2023-03-17 11:33:51', '2023-03-17 11:33:11', '57', '63', '17', '0.000000', null, '-10.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '10.300000', null, null, '0', '0', null, '63', '0', null), ('290', '其它', '采购订单', 'CGDD00000000912', 'CGDD00000000912', '2023-03-20 18:36:39', '2023-03-20 18:36:20', '57', '63', '17', '0.000000', null, '-120.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '123.600000', null, null, '0', '0', null, '63', '1', null), ('291', '其它', '采购订单', 'CGDD00000000917', 'CGDD00000000917', '2023-03-20 19:31:15', '2023-03-20 19:30:59', '57', '63', '17', '0.000000', null, '-270.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '0.000000', null, null, '0', '0', null, '63', '0', null), ('292', '其它', '采购订单', 'CGDD00000000918', 'CGDD00000000918', '2023-03-20 19:51:33', '2023-03-20 19:50:14', '75', '146', '17', '0.000000', null, '-880.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '990.000000', null, null, '2', '0', null, '63', '0', null), ('293', '入库', '采购', 'CGRK00000000919', 'CGRK00000000919', '2023-03-20 19:55:16', '2023-03-20 19:51:46', '75', '146', '17', '-994.400000', null, '-880.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '994.400000', '0.000000', null, '1', '0', 'CGDD00000000918', '63', '0', null), ('294', '出库', '其它', 'QTCK00000000921', 'QTCK00000000921', '2023-03-20 20:04:39', '2023-03-20 20:02:21', null, '147', null, null, null, '0.000000', '现付', null, null, '', null, null, null, null, null, null, null, null, '1', '0', null, '63', '0', null), ('295', '其它', '销售订单', 'XSDD00000000928', 'XSDD00000000928', '2023-03-20 20:12:16', '2023-03-20 20:11:56', '58', '146', '17', '0.000000', null, '1200.000000', '现付', null, null, '', '', '', '', '0.000000', '0.000000', '1356.000000', null, null, '1', '0', null, '63', '0', null), ('296', '其它', '销售订单', 'XSDD00000000932', 'XSDD00000000932', '2023-03-20 20:19:06', '2023-03-20 20:18:01', '58', '148', '17', '0.000000', null, '884.960000', '现付', null, null, '', '', '', '', '0.000000', '0.000000', '1000.000000', null, null, '2', '0', null, '63', '0', null), ('297', '其它', '采购订单', 'CGDD00000000933', 'CGDD00000000933', '2023-03-20 20:20:56', '2023-03-20 20:19:34', '75', '146', '17', '0.000000', null, '-17.700000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '20.000000', null, null, '2', '0', null, '63', '0', null), ('298', '入库', '采购', 'CGRK00000000935', 'CGRK00000000935', '2023-03-20 20:22:00', '2023-03-20 20:21:16', '75', '146', '17', '-20.000000', null, '-17.700000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '20.000000', '0.000000', null, '1', '0', 'CGDD00000000933', '63', '0', null), ('299', '其它', '组装单', 'ZZD00000000936', 'ZZD00000000936', '2023-03-20 20:30:23', '2023-03-20 20:29:23', null, '147', null, null, null, '0.000000', '现付', null, null, '', null, null, null, null, null, null, null, null, '1', '0', null, '63', '0', null), ('300', '出库', '销售', 'XSCK00000000938', 'XSCK00000000938', '2023-03-20 20:37:13', '2023-03-20 20:35:26', '58', '147', '17', '1000.000000', null, '884.960000', '现付', null, null, '', '', '', '', '0.000000', '0.000000', '1000.000000', '0.000000', null, '1', '0', 'XSDD00000000932', '63', '0', null), ('301', '其它', '销售订单', 'XSDD00000001040', 'XSDD00000001040', '2023-03-21 01:26:59', '2023-03-21 01:26:32', '58', '63', '17', '0.000000', null, '2800.000000', '现付', null, null, '', '', '', '', '0.000000', '0.000000', '2830.000000', null, null, '1', '0', null, '63', '0', null), ('302', '其它', '采购订单', 'CGDD2023038100010', 'CGDD2023038100010', '2023-03-22 11:29:33', '2023-03-22 11:28:03', '57', '63', '17', '0.000000', null, '-9710.000000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '10000.000000', null, null, '1', '0', null, '63', '0', null), ('303', '其它', '采购订单', 'CGDD2023038200001', 'CGDD2023038200001', '2023-03-23 12:45:35', '2023-03-23 12:44:49', '57', '63', '17', '0.000000', null, '-970.900000', '现付', null, null, '', null, '', '', '0.000000', '0.000000', '1000.000000', null, null, '0', '0', null, '63', '0', null);
COMMIT;

-- ----------------------------
--  Table structure for `jsh_depot_item`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_depot_item`;
CREATE TABLE `jsh_depot_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `header_id` bigint(20) NOT NULL COMMENT '表头Id',
  `material_id` bigint(20) NOT NULL COMMENT '商品Id',
  `material_extend_id` bigint(20) DEFAULT NULL COMMENT '商品扩展id',
  `material_unit` varchar(20) DEFAULT NULL COMMENT '商品计量单位',
  `sku` varchar(50) DEFAULT NULL COMMENT '多属性',
  `oper_number` decimal(24,6) DEFAULT NULL COMMENT '数量',
  `basic_number` decimal(24,6) DEFAULT NULL COMMENT '基础数量，如kg、瓶',
  `unit_price` decimal(24,6) DEFAULT NULL COMMENT '单价',
  `purchase_unit_price` decimal(24,6) DEFAULT NULL COMMENT '采购单价',
  `tax_unit_price` decimal(24,6) DEFAULT NULL COMMENT '含税单价',
  `all_price` decimal(24,6) DEFAULT NULL COMMENT '金额',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `depot_id` bigint(20) DEFAULT NULL COMMENT '仓库ID',
  `another_depot_id` bigint(20) DEFAULT NULL COMMENT '调拨时，对方仓库Id',
  `tax_rate` decimal(24,6) DEFAULT NULL COMMENT '税率',
  `tax_money` decimal(24,6) DEFAULT NULL COMMENT '税额',
  `tax_last_money` decimal(24,6) DEFAULT NULL COMMENT '价税合计',
  `material_type` varchar(20) DEFAULT NULL COMMENT '商品类型',
  `sn_list` varchar(2000) DEFAULT NULL COMMENT '序列号列表',
  `batch_number` varchar(100) DEFAULT NULL COMMENT '批号',
  `expiration_date` datetime DEFAULT NULL COMMENT '有效日期',
  `link_id` bigint(20) DEFAULT NULL COMMENT '关联明细id',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK2A819F475D61CCF7` (`material_id`),
  KEY `FK2A819F474BB6190E` (`header_id`),
  KEY `FK2A819F479485B3F5` (`depot_id`),
  KEY `FK2A819F47729F5392` (`another_depot_id`)
) ENGINE=InnoDB AUTO_INCREMENT=391 DEFAULT CHARSET=utf8 COMMENT='单据子表';

-- ----------------------------
--  Records of `jsh_depot_item`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_depot_item` VALUES ('312', '258', '588', '10', '个', null, '10.000000', '10.000000', '11.000000', null, null, '110.000000', null, '14', null, null, null, null, null, null, null, null, null, '63', '1'), ('313', '259', '588', '10', '个', null, '10.000000', '10.000000', '11.000000', null, null, '110.000000', null, '14', null, null, '0.000000', '110.000000', null, null, null, null, null, '63', '1'), ('314', '260', '588', '10', '个', null, '2.000000', '2.000000', '11.000000', null, '11.000000', '22.000000', null, '14', null, '0.000000', '0.000000', '22.000000', null, null, null, null, null, '63', '1'), ('315', '261', '588', '10', '个', null, '2.000000', '2.000000', '22.000000', null, null, '44.000000', null, '14', null, null, null, null, null, null, null, null, null, '63', '1'), ('316', '262', '588', '10', '个', null, '2.000000', '2.000000', '22.000000', null, null, '44.000000', null, '14', null, null, '0.000000', '44.000000', null, null, null, null, null, '63', '1'), ('317', '263', '588', '10', '个', null, '1.000000', '1.000000', '22.000000', null, '22.000000', '22.000000', null, '14', null, '0.000000', '0.000000', '22.000000', null, null, null, null, null, '63', '1'), ('318', '264', '588', '10', '个', null, '1.000000', '1.000000', '22.000000', null, null, '22.000000', null, '14', null, null, null, null, null, null, null, null, null, '63', '1'), ('319', '265', '588', '10', '个', null, '1.000000', '1.000000', '22.000000', null, null, '22.000000', null, '14', null, null, null, null, null, null, null, null, null, '63', '1'), ('320', '266', '568', '2', '个', null, '5.000000', '5.000000', '11.000000', null, null, '55.000000', null, '14', null, null, null, null, null, null, null, null, null, '63', '1'), ('321', '267', '568', '2', '个', null, '2.000000', '2.000000', '15.000000', null, null, '30.000000', null, '14', null, null, null, null, null, null, null, null, null, '63', '1'), ('322', '268', '568', '2', '个', null, '1.000000', '1.000000', '11.000000', null, null, '11.000000', null, '14', '15', null, null, null, null, null, null, null, null, '63', '1'), ('323', '269', '588', '10', '个', null, '1.000000', '1.000000', '0.000000', null, null, '0.000000', null, '14', null, null, null, null, '组合件', null, null, null, null, '63', '1'), ('324', '269', '568', '2', '个', null, '1.000000', '1.000000', '0.000000', null, null, '0.000000', null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '1'), ('325', '270', '588', '10', '个', null, '1.000000', '1.000000', '0.000000', null, null, '0.000000', null, '14', null, null, null, null, '组合件', null, null, null, null, '63', '1'), ('326', '270', '568', '2', '个', null, '1.000000', '1.000000', '0.000000', null, null, '0.000000', null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '1'), ('327', '271', '570', '4', '个', null, '10.000000', '10.000000', '8.000000', null, '8.000000', '80.000000', null, '14', null, '0.000000', '0.000000', '80.000000', null, null, null, null, null, '63', '1'), ('328', '272', '570', '4', '个', null, '2.000000', '2.000000', '14.000000', null, '14.000000', '28.000000', null, '14', null, '0.000000', '0.000000', '28.000000', null, null, null, null, null, '63', '1'), ('330', '273', '619', '37', '件', '橙色,L', '5.000000', '5.000000', '12.000000', null, '12.000000', '60.000000', null, '14', null, '0.000000', '0.000000', '60.000000', null, null, null, null, null, '63', '1'), ('331', '274', '621', '41', '10', null, '1.000000', '1.000000', null, null, null, null, null, null, null, '0.000000', '0.000000', null, null, null, null, null, null, '63', '1'), ('332', '275', '621', '41', '10', null, '1.000000', '1.000000', null, null, null, null, null, '14', null, '0.000000', '0.000000', null, null, null, null, null, '331', '63', '1'), ('335', '276', '621', '41', '只', null, '20.000000', '20.000000', null, null, null, '0.000000', null, null, null, '0.000000', '0.000000', '0.000000', null, null, null, null, null, '63', '1'), ('336', '276', '620', '40', '个', '1', '1.000000', '1.000000', null, null, null, null, null, null, null, '0.000000', '0.000000', null, null, null, null, null, null, '63', '1'), ('337', '277', '621', '41', '只', null, '20.000000', '20.000000', null, null, null, '0.000000', null, '14', null, '0.000000', '0.000000', '0.000000', null, null, null, null, '335', '63', '1'), ('338', '277', '620', '40', '个', '1', '1.000000', '1.000000', null, null, null, null, null, '14', null, '0.000000', '0.000000', null, null, null, null, null, '336', '63', '1'), ('339', '278', '620', '40', '个', '1', '20.000000', '20.000000', '20.000000', null, null, '400.000000', null, null, null, '0.000000', '0.000000', '400.000000', null, null, null, null, null, '63', '1'), ('340', '279', '620', '40', '个', '1', '20.000000', '20.000000', '20.000000', null, null, '400.000000', null, '14', null, '0.000000', '0.000000', '400.000000', null, null, null, null, '339', '63', '1'), ('341', '280', '621', '41', '只', null, '10.000000', '10.000000', '1.000000', null, null, '10.000000', null, '14', null, '0.000000', '0.000000', '10.000000', null, null, null, null, '337', '63', '1'), ('342', '280', '620', '40', '个', '1', '1.000000', '1.000000', null, null, null, null, null, '14', null, '0.000000', '0.000000', null, null, null, null, null, '338', '63', '1'), ('343', '281', '624', '46', '个', null, '1.000000', '1.000000', null, null, null, null, null, '14', null, null, null, null, '组合件', null, null, null, null, '63', '0'), ('344', '281', '622', '42', '个', null, '1.000000', '1.000000', '1.000000', null, null, '1.000000', null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('345', '281', '623', '45', '个', null, '1.000000', '1.000000', '1.000000', null, null, '1.000000', null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('346', '282', '624', '46', '个', null, '1.000000', '1.000000', null, null, null, null, null, '14', null, null, null, null, '组合件', null, null, null, null, '63', '0'), ('347', '282', '623', '45', '个', null, '1.000000', '1.000000', '1.000000', null, null, '1.000000', null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('348', '282', '622', '42', '个', null, '1.000000', '1.000000', '1.000000', null, null, '1.000000', null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('349', '283', '623', '45', '个', null, '100.000000', '100.000000', '1.000000', null, null, '100.000000', null, '14', null, null, null, null, null, null, null, null, null, '63', '0'), ('350', '283', '622', '42', '个', null, '100.000000', '100.000000', '1.000000', null, null, '100.000000', null, '14', null, null, null, null, null, null, null, null, null, '63', '0'), ('351', '284', '622', '42', '个', null, '10.000000', '10.000000', '1.000000', null, null, '10.000000', null, null, null, '0.000000', '0.000000', '10.000000', null, null, null, null, null, '63', '0'), ('352', '284', '623', '45', '个', null, '1.000000', '1.000000', '1.000000', null, null, '1.000000', null, null, null, '0.000000', '0.000000', '1.000000', null, null, null, null, null, '63', '0'), ('353', '285', '622', '42', '个', null, '5.000000', '5.000000', '1.000000', null, null, '5.000000', null, '14', null, '0.000000', '0.000000', '5.000000', null, null, null, null, '351', '63', '0'), ('354', '286', '624', '46', '个', null, '1.000000', '1.000000', null, null, null, null, null, '14', null, null, null, null, '组合件', null, null, null, null, '63', '0'), ('355', '286', '623', '45', '个', null, '1.000000', '1.000000', '1.000000', null, null, '1.000000', null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('356', '286', '622', '42', '个', null, '1.000000', '1.000000', '1.000000', null, null, '1.000000', null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('357', '287', '625', '48', '个', null, '1.000000', '1.000000', null, null, null, null, null, '14', null, null, null, null, '组合件', null, null, null, null, '63', '0'), ('358', '287', '623', '45', '个', null, '3.000000', '3.000000', null, null, null, null, null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('359', '287', '622', '42', '个', null, '2.000000', '2.000000', null, null, null, null, null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('360', '288', '625', '48', '个', null, '1.000000', '1.000000', null, null, null, null, null, '14', null, null, null, null, '组合件', null, null, null, null, '63', '0'), ('361', '288', '623', '45', '个', null, '3.000000', '3.000000', null, null, null, null, null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('362', '288', '622', '42', '个', null, '2.000000', '2.000000', null, null, null, null, null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('366', '289', '623', '45', '个', null, '10.000000', '10.000000', '1.000000', null, null, '10.000000', '1', null, null, '3.000000', '0.300000', '10.300000', null, null, null, null, null, '63', '0'), ('367', '290', '623', '45', '', null, '10.000000', '10.000000', '12.000000', null, null, '120.000000', null, null, null, '3.000000', '3.600000', '123.600000', null, null, null, null, null, '63', '1'), ('368', '291', '622', '42', '个', null, '15.000000', '15.000000', '10.000000', null, null, '150.000000', null, null, null, '0.000000', '0.000000', '150.000000', null, null, null, null, null, '63', '0'), ('369', '291', '623', '45', '个', null, '10.000000', '10.000000', '12.000000', null, null, '120.000000', null, null, null, '3.000000', '3.600000', '123.600000', null, null, null, null, null, '63', '0'), ('370', '292', '626', '49', '个', null, '1000.000000', '1000.000000', '0.880000', null, null, '880.000000', null, null, null, '13.000000', '110.000000', '990.000000', null, null, null, null, null, '63', '0'), ('371', '293', '626', '49', '个', null, '1000.000000', '1000.000000', '0.880000', null, null, '880.000000', null, '17', null, '13.000000', '114.400000', '994.400000', null, null, null, null, '370', '63', '0'), ('372', '294', '626', '49', '个', null, '500.000000', '500.000000', null, null, null, '0.000000', null, '17', null, null, null, null, null, null, null, null, null, '63', '0'), ('374', '296', '625', '48', '个', null, '1.000000', '1.000000', '884.960000', null, null, '884.960000', null, null, null, '13.000000', '115.040000', '1000.000000', null, null, null, null, null, '63', '0'), ('375', '297', '622', '42', '个', null, '1.000000', '1.000000', '8.850000', null, null, '8.850000', null, null, null, '13.000000', '1.150000', '10.000000', null, null, null, null, null, '63', '0'), ('376', '297', '623', '45', '个', null, '1.000000', '1.000000', '8.850000', null, null, '8.850000', null, null, null, '13.000000', '1.150000', '10.000000', null, null, null, null, null, '63', '0'), ('377', '298', '622', '42', '个', null, '1.000000', '1.000000', '8.850000', null, null, '8.850000', null, '14', null, '13.000000', '1.150000', '10.000000', null, null, null, null, '375', '63', '0'), ('378', '298', '623', '45', '个', null, '1.000000', '1.000000', '8.850000', null, null, '8.850000', null, '14', null, '13.000000', '1.150000', '10.000000', null, null, null, null, '376', '63', '0'), ('379', '299', '625', '48', '个', null, '1.000000', '1.000000', null, null, null, null, null, '14', null, null, null, null, '组合件', null, null, null, null, '63', '0'), ('380', '299', '623', '45', '个', null, '2.000000', '2.000000', null, null, null, null, null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('381', '299', '622', '42', '个', null, '1.000000', '1.000000', null, null, null, null, null, '14', null, null, null, null, '普通子件', null, null, null, null, '63', '0'), ('382', '300', '625', '48', '个', null, '1.000000', '1.000000', '884.960000', null, null, '884.960000', null, '14', null, '13.000000', '115.040000', '1000.000000', null, null, null, null, '374', '63', '0'), ('383', '295', '625', '48', '个', null, '3.000000', '3.000000', '400.000000', null, null, '1200.000000', null, null, null, '13.000000', '156.000000', '1356.000000', null, null, null, null, null, '63', '0'), ('386', '301', '622', '42', '个', null, '1.000000', '1.000000', '0.000000', null, null, '0.000000', null, null, null, '0.000000', '0.000000', '0.000000', null, null, null, null, null, '63', '0'), ('387', '301', '625', '48', '个', null, '2.000000', '2.000000', '900.000000', null, null, '1800.000000', null, null, null, '0.000000', '0.000000', '1800.000000', null, null, null, null, null, '63', '0'), ('388', '301', '626', '49', '个', null, '10.000000', '10.000000', '100.000000', null, null, '1000.000000', null, null, null, '3.000000', '30.000000', '1030.000000', null, null, null, null, null, '63', '0'), ('389', '302', '622', '42', '个', null, '1000.000000', '1000.000000', '9.710000', null, '10.000000', '9710.000000', null, null, null, '3.000000', '290.000000', '10000.000000', null, null, null, null, null, '63', '0'), ('390', '303', '622', '42', '个', null, '10.000000', '10.000000', '97.090000', null, '100.000000', '970.900000', null, null, null, '3.000000', '29.100000', '1000.000000', null, null, null, null, null, '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_function`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_function`;
CREATE TABLE `jsh_function` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `number` varchar(50) DEFAULT NULL COMMENT '编号',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `parent_number` varchar(50) DEFAULT NULL COMMENT '上级编号',
  `url` varchar(100) DEFAULT NULL COMMENT '链接',
  `component` varchar(100) DEFAULT NULL COMMENT '组件',
  `state` bit(1) DEFAULT NULL COMMENT '收缩',
  `sort` varchar(50) DEFAULT NULL COMMENT '排序',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `type` varchar(50) DEFAULT NULL COMMENT '类型',
  `push_btn` varchar(50) DEFAULT NULL COMMENT '功能按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  UNIQUE KEY `url` (`url`)
) ENGINE=InnoDB AUTO_INCREMENT=262 DEFAULT CHARSET=utf8 COMMENT='功能模块表';

-- ----------------------------
--  Records of `jsh_function`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_function` VALUES ('1', '0001', '系统管理', '0', '/system', '/layouts/TabLayout', b'1', '0910', b'1', '电脑版', '', 'setting', '0'), ('13', '000102', '角色管理', '0001', '/system/role', '/system/RoleList', b'0', '0130', b'1', '电脑版', '1', 'profile', '0'), ('14', '000103', '用户管理', '0001', '/system/user', '/system/UserList', b'0', '0140', b'1', '电脑版', '1', 'profile', '0'), ('15', '000104', '日志管理', '0001', '/system/log', '/system/LogList', b'0', '0160', b'1', '电脑版', '', 'profile', '0'), ('16', '000105', '功能管理', '0001', '/system/function', '/system/FunctionList', b'0', '0166', b'1', '电脑版', '1', 'profile', '0'), ('18', '000109', '租户管理', '0001', '/system/tenant', '/system/TenantList', b'0', '0167', b'1', '电脑版', '1', 'profile', '0'), ('21', '0101', '商品管理', '0', '/material', '/layouts/TabLayout', b'0', '0620', b'1', '电脑版', null, 'shopping', '0'), ('22', '010101', '商品类别', '0101', '/material/material_category', '/material/MaterialCategoryList', b'0', '0230', b'1', '电脑版', '1', 'profile', '0'), ('23', '010102', '商品信息', '0101', '/material/material', '/material/MaterialList', b'0', '0240', b'1', '电脑版', '1', 'profile', '0'), ('24', '0102', '基本资料', '0', '/systemA', '/layouts/TabLayout', b'0', '0750', b'1', '电脑版', null, 'appstore', '0'), ('25', '01020101', '供应商信息', '0102', '/system/vendor', '/system/VendorList', b'0', '0260', b'1', '电脑版', '1', 'profile', '0'), ('26', '010202', '仓库信息', '0102', '/system/depot', '/system/DepotList', b'0', '0270', b'1', '电脑版', '1', 'profile', '0'), ('31', '010206', '经手人管理', '0102', '/system/person', '/system/PersonList', b'0', '0284', b'1', '电脑版', '1', 'profile', '0'), ('32', '0502', '采购管理', '0', '/bill', '/layouts/TabLayout', b'0', '0330', b'1', '电脑版', '', 'retweet', '0'), ('33', '050201', '采购入库', '0502', '/bill/purchase_in', '/bill/PurchaseInList', b'0', '0340', b'1', '电脑版', '1,2,7', 'profile', '0'), ('38', '0603', '销售管理', '0', '/billB', '/layouts/TabLayout', b'0', '0390', b'1', '电脑版', '', 'shopping-cart', '0'), ('40', '080107', '调拨出库', '0801', '/bill/allocation_out', '/bill/AllocationOutList', b'0', '0807', b'1', '电脑版', '1,2,7', 'profile', '0'), ('41', '060303', '销售出库', '0603', '/bill/sale_out', '/bill/SaleOutList', b'0', '0394', b'1', '电脑版', '1,2,7', 'profile', '0'), ('44', '0704', '财务管理', '0', '/financial', '/layouts/TabLayout', b'0', '0450', b'1', '电脑版', '', 'money-collect', '0'), ('59', '030101', '进销存统计', '0301', '/report/in_out_stock_report', '/report/InOutStockReport', b'0', '0658', b'1', '电脑版', '', 'profile', '0'), ('194', '010204', '收支项目', '0102', '/system/in_out_item', '/system/InOutItemList', b'0', '0282', b'1', '电脑版', '1', 'profile', '0'), ('195', '010205', '结算账户', '0102', '/system/account', '/system/AccountList', b'0', '0283', b'1', '电脑版', '1', 'profile', '0'), ('197', '070402', '收入单', '0704', '/financial/item_in', '/financial/ItemInList', b'0', '0465', b'1', '电脑版', '1,2,7', 'profile', '0'), ('198', '0301', '报表查询', '0', '/report', '/layouts/TabLayout', b'0', '0570', b'1', '电脑版', null, 'pie-chart', '0'), ('199', '050204', '采购退货', '0502', '/bill/purchase_back', '/bill/PurchaseBackList', b'0', '0345', b'1', '电脑版', '1,2,7', 'profile', '0'), ('200', '060305', '销售退货', '0603', '/bill/sale_back', '/bill/SaleBackList', b'0', '0396', b'1', '电脑版', '1,2,7', 'profile', '0'), ('201', '080103', '其它入库', '0801', '/bill/other_in', '/bill/OtherInList', b'0', '0803', b'1', '电脑版', '1,2,7', 'profile', '0'), ('202', '080105', '其它出库', '0801', '/bill/other_out', '/bill/OtherOutList', b'0', '0805', b'1', '电脑版', '1,2,7', 'profile', '0'), ('203', '070403', '支出单', '0704', '/financial/item_out', '/financial/ItemOutList', b'0', '0470', b'1', '电脑版', '1,2,7', 'profile', '0'), ('204', '070404', '收款单', '0704', '/financial/money_in', '/financial/MoneyInList', b'0', '0475', b'1', '电脑版', '1,2,7', 'profile', '0'), ('205', '070405', '付款单', '0704', '/financial/money_out', '/financial/MoneyOutList', b'0', '0480', b'1', '电脑版', '1,2,7', 'profile', '0'), ('206', '070406', '转账单', '0704', '/financial/giro', '/financial/GiroList', b'0', '0490', b'1', '电脑版', '1,2,7', 'profile', '0'), ('207', '030102', '账户统计', '0301', '/report/account_report', '/report/AccountReport', b'0', '0610', b'1', '电脑版', '', 'profile', '0'), ('208', '030103', '采购统计', '0301', '/report/buy_in_report', '/report/BuyInReport', b'0', '0620', b'1', '电脑版', '', 'profile', '0'), ('209', '030104', '销售统计', '0301', '/report/sale_out_report', '/report/SaleOutReport', b'0', '0630', b'1', '电脑版', '', 'profile', '0'), ('210', '040102', '零售出库', '0401', '/bill/retail_out', '/bill/RetailOutList', b'0', '0405', b'1', '电脑版', '1,2,7', 'profile', '0'), ('211', '040104', '零售退货', '0401', '/bill/retail_back', '/bill/RetailBackList', b'0', '0407', b'1', '电脑版', '1,2,7', 'profile', '0'), ('212', '070407', '收预付款', '0704', '/financial/advance_in', '/financial/AdvanceInList', b'0', '0495', b'1', '电脑版', '1,2,7', 'profile', '0'), ('217', '01020102', '客户信息', '0102', '/system/customer', '/system/CustomerList', b'0', '0262', b'1', '电脑版', '1', 'profile', '0'), ('218', '01020103', '会员信息', '0102', '/system/member', '/system/MemberList', b'0', '0263', b'1', '电脑版', '1', 'profile', '0'), ('220', '010103', '计量单位', '0101', '/system/unit', '/system/UnitList', b'0', '0245', b'1', '电脑版', '1', 'profile', '0'), ('225', '0401', '零售管理', '0', '/billC', '/layouts/TabLayout', b'0', '0101', b'1', '电脑版', '', 'gift', '0'), ('226', '030106', '入库明细', '0301', '/report/in_detail', '/report/InDetail', b'0', '0640', b'1', '电脑版', '', 'profile', '0'), ('227', '030107', '出库明细', '0301', '/report/out_detail', '/report/OutDetail', b'0', '0645', b'1', '电脑版', '', 'profile', '0'), ('228', '030108', '入库汇总', '0301', '/report/in_material_count', '/report/InMaterialCount', b'0', '0650', b'1', '电脑版', '', 'profile', '0'), ('229', '030109', '出库汇总', '0301', '/report/out_material_count', '/report/OutMaterialCount', b'0', '0655', b'1', '电脑版', '', 'profile', '0'), ('232', '080109', '组装单', '0801', '/bill/assemble', '/bill/AssembleList', b'0', '0809', b'1', '电脑版', '1,2,7', 'profile', '0'), ('233', '080111', '拆卸单', '0801', '/bill/disassemble', '/bill/DisassembleList', b'0', '0811', b'1', '电脑版', '1,2,7', 'profile', '0'), ('234', '000105', '系统配置', '0001', '/system/system_config', '/system/SystemConfigList', b'0', '0165', b'1', '电脑版', '1', 'profile', '0'), ('235', '030110', '客户对账', '0301', '/report/customer_account', '/report/CustomerAccount', b'0', '0660', b'1', '电脑版', '', 'profile', '0'), ('236', '000106', '商品属性', '0001', '/material/material_property', '/material/MaterialPropertyList', b'0', '0168', b'1', '电脑版', '1', 'profile', '0'), ('237', '030111', '供应商对账', '0301', '/report/vendor_account', '/report/VendorAccount', b'0', '0665', b'1', '电脑版', '', 'profile', '0'), ('239', '0801', '仓库管理', '0', '/billD', '/layouts/TabLayout', b'0', '0420', b'1', '电脑版', '', 'hdd', '0'), ('241', '050202', '采购订单', '0502', '/bill/purchase_order', '/bill/PurchaseOrderList', b'0', '0335', b'1', '电脑版', '1,2,7', 'profile', '0'), ('242', '060301', '销售订单', '0603', '/bill/sale_order', '/bill/SaleOrderList', b'0', '0392', b'1', '电脑版', '1,2,7', 'profile', '0'), ('243', '000108', '机构管理', '0001', '/system/organization', '/system/OrganizationList', b'1', '0150', b'1', '电脑版', '1', 'profile', '0'), ('244', '030112', '库存预警', '0301', '/report/stock_warning_report', '/report/StockWarningReport', b'0', '0670', b'1', '电脑版', '', 'profile', '0'), ('245', '000107', '插件管理', '0001', '/system/plugin', '/system/PluginList', b'0', '0170', b'1', '电脑版', '1', 'profile', '0'), ('246', '030113', '商品库存', '0301', '/report/material_stock', '/report/MaterialStock', b'0', '0605', b'1', '电脑版', '', 'profile', '0'), ('247', '010105', '多属性', '0101', '/material/material_attribute', '/material/MaterialAttributeList', b'0', '0250', b'1', '电脑版', '1', 'profile', '0'), ('248', '030150', '调拨明细', '0301', '/report/allocation_detail', '/report/AllocationDetail', b'0', '0646', b'1', '电脑版', '', 'profile', '0'), ('258', '000112', '平台配置', '0001', '/system/platform_config', '/system/PlatformConfigList', b'0', '0175', b'1', '电脑版', '', 'profile', '0'), ('260', '0901', '生产管理', '0', '/production', '/layouts/TabLayout', b'0', '0901', b'1', '电脑版', '', 'profile', '0'), ('261', '090101', 'BOM列表', '0901', '/production/bom_list', '/production/BomList', b'0', '0901', b'1', '电脑版', '1', 'profile', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_in_out_item`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_in_out_item`;
CREATE TABLE `jsh_in_out_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='收支项目';

-- ----------------------------
--  Records of `jsh_in_out_item`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_in_out_item` VALUES ('21', '快递费', '支出', '', b'1', null, '63', '0'), ('22', '房租收入', '收入', '', b'1', null, '63', '0'), ('23', '利息收入', '收入', '收入', b'1', null, '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_log`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_log`;
CREATE TABLE `jsh_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `operation` varchar(500) DEFAULT NULL COMMENT '操作模块名称',
  `client_ip` varchar(200) DEFAULT NULL COMMENT '客户端IP',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` tinyint(4) DEFAULT NULL COMMENT '操作状态 0==成功，1==失败',
  `content` varchar(1000) DEFAULT NULL COMMENT '详情',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`),
  KEY `FKF2696AA13E226853` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7757 DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
--  Records of `jsh_log`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_log` VALUES ('7559', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 18:01:25', '0', '登录jsh', '63'), ('7560', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-06 18:05:02', '0', '新增马克杯', '63'), ('7561', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-06 18:06:01', '0', '新增马克杯', '63'), ('7562', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 18:08:37', '0', '新增CGDD00000000666', '63'), ('7563', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 18:10:10', '0', '新增CGRK00000000667', '63'), ('7564', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-06 21:20:56', '0', '修改马克杯', '63'), ('7565', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-06 21:21:05', '0', '修改马克杯2', '63'), ('7566', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 21:25:01', '0', '新增CGDD00000000669', '63'), ('7567', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 21:25:57', '0', '修改CGDD00000000669', '63'), ('7568', '63', '账户', '127.0.0.1/127.0.0.1', '2023-03-06 21:28:47', '0', '修改账户1', '63'), ('7569', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 21:30:44', '0', '新增CGRK00000000675', '63'), ('7570', '63', '系统配置', '127.0.0.1/127.0.0.1', '2023-03-06 21:36:43', '0', '修改珠海城电科技有限公司', '63'), ('7571', '63', '角色', '127.0.0.1/127.0.0.1', '2023-03-06 21:37:06', '0', '新增采购', '63'), ('7572', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:37:40', '0', '新增', '63'), ('7573', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:37:49', '0', '修改角色的按钮权限', '63'), ('7574', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 21:38:17', '0', '新增', '63'), ('7575', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:38:17', '0', '新增', '63'), ('7576', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 21:38:31', '0', '登录cg', '63'), ('7577', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 21:39:51', '0', '登录jsh', '63'), ('7578', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:40:09', '0', '修改', '63'), ('7579', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 21:43:13', '0', '登录cg', '63'), ('7580', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:43:56', '0', '修改', '63'), ('7581', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:44:07', '0', '修改角色的按钮权限', '63'), ('7582', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 21:44:22', '0', '登录cg', '63'), ('7583', '63', '角色', '127.0.0.1/127.0.0.1', '2023-03-06 21:47:02', '0', '新增仓库管理员', '63'), ('7584', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:47:22', '0', '新增', '63'), ('7585', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:47:31', '0', '修改角色的按钮权限', '63'), ('7586', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 21:48:00', '0', '新增', '63'), ('7587', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:48:00', '0', '新增', '63'), ('7588', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 21:53:23', '0', '修改63', '63'), ('7589', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:53:23', '0', '修改', '63'), ('7590', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 21:53:38', '0', '修改63', '63'), ('7591', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 21:53:38', '0', '修改', '63'), ('7592', '63', '角色', '127.0.0.1/127.0.0.1', '2023-03-06 21:54:37', '0', '修改销售代表', '63'), ('7593', '63', '角色', '127.0.0.1/127.0.0.1', '2023-03-06 21:54:40', '0', '修改销售经理', '63'), ('7594', '63', '账户', '127.0.0.1/127.0.0.1', '2023-03-06 21:55:44', '0', '修改账户1', '63'), ('7595', '63', '账户', '127.0.0.1/127.0.0.1', '2023-03-06 21:56:12', '0', '修改账户1', '63'), ('7596', '63', '账户', '127.0.0.1/127.0.0.1', '2023-03-06 21:56:17', '0', '修改账户2', '63'), ('7597', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 22:00:58', '0', '登录cg', '63'), ('7598', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 22:03:01', '0', '登录jsh', '63'), ('7599', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 22:04:17', '0', '新增CGDD00000000678', '63'), ('7600', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 22:04:35', '0', '修改', '63'), ('7601', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-06 22:04:40', '0', '修改角色的按钮权限', '63'), ('7602', '147', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 22:05:33', '0', '登录ckgl', '63'), ('7603', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 22:06:46', '0', '新增CGRK00000000679', '63'), ('7604', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 22:07:06', '0', '删除[CGTH00000000632]', '63'), ('7605', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-06 22:07:45', '0', '新增CGTH00000000680', '63'), ('7606', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-06 22:08:42', '0', '登录cg', '63'), ('7607', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-09 18:11:07', '0', '登录jsh', '63'), ('7608', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 18:14:35', '0', '修改太阳花1', '63'), ('7609', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 18:17:59', '0', '修改太阳花', '63'), ('7610', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 18:18:36', '0', '修改大太阳花', '63'), ('7611', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 18:19:02', '0', '新增小太阳花', '63'), ('7612', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 18:21:52', '0', '新增电池', '63'), ('7613', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:36:06', '0', '修改电池', '63'), ('7614', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:36:28', '0', '修改电池', '63'), ('7615', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:36:42', '0', '修改电池', '63'), ('7616', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:38:16', '0', '删除[CGTH00000000680]', '63'), ('7617', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:38:34', '0', '删除[CGRK00000000631][CGRK00000000651][CGRK00000000658]', '63'), ('7618', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:38:44', '0', '删除[CGRK00000000667][CGRK00000000675][CGRK00000000679]', '63'), ('7619', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:38:54', '0', '删除[CGDD00000000630][CGDD00000000666][CGDD00000000669][CGDD00000000678]', '63'), ('7620', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:39:10', '0', '删除[XSCK00000000634][XSCK00000000652]', '63'), ('7621', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:39:15', '0', '删除[XSTH00000000635]', '63'), ('7622', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:39:26', '0', '删除[XSDD00000000633]', '63'), ('7623', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:39:38', '0', '删除[QTRK00000000638]', '63'), ('7624', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:39:44', '0', '删除[QTCK00000000639]', '63'), ('7625', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:39:47', '0', '删除[DBCK00000000640]', '63'), ('7626', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:41:26', '0', '删除[ZZD00000000641]', '63'), ('7627', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:41:38', '0', '删除[CXD00000000642]', '63'), ('7628', '63', '财务', '127.0.0.1/127.0.0.1', '2023-03-09 21:42:32', '0', '删除[SR00000000643]', '63'), ('7629', '63', '财务', '127.0.0.1/127.0.0.1', '2023-03-09 21:42:37', '0', '删除[ZC00000000644]', '63'), ('7630', '63', '财务', '127.0.0.1/127.0.0.1', '2023-03-09 21:42:40', '0', '删除[SK00000000653]', '63'), ('7631', '63', '财务', '127.0.0.1/127.0.0.1', '2023-03-09 21:42:44', '0', '删除[FK00000000654]', '63'), ('7632', '63', '财务', '127.0.0.1/127.0.0.1', '2023-03-09 21:42:47', '0', '删除[ZZ00000000647]', '63'), ('7633', '63', '财务', '127.0.0.1/127.0.0.1', '2023-03-09 21:42:50', '0', '删除[SYF00000000649]', '63'), ('7634', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:43:47', '0', '删除[LSCK00000000636]', '63'), ('7635', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:43:50', '0', '删除[LSTH00000000637]', '63'), ('7636', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:44:09', '0', '删除[商品3][商品8][商品17][序列号商品测试][商品test1][商品200][衣服][马克杯][马克杯2]', '63'), ('7637', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:44:29', '0', '删除[商品1][商品2]', '63'), ('7638', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:47:51', '0', '新增支架', '63'), ('7639', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:48:10', '0', '修改电池', '63'), ('7640', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:54:12', '0', '新增太阳花', '63'), ('7641', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 21:54:57', '0', '新增成品', '63'), ('7642', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 21:55:17', '0', '修改原料', '63'), ('7643', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 21:55:33', '0', '新增太阳花', '63'), ('7644', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 21:55:37', '0', '修改太阳花', '63'), ('7645', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:56:05', '0', '修改电池', '63'), ('7646', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 21:56:10', '0', '修改支架', '63'), ('7647', '63', '商品类型', '127.0.0.1/127.0.0.1', '2023-03-09 21:56:15', '0', '删除[大太阳花][小太阳花]', '63'), ('7648', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:57:44', '0', '新增ZZD00000000693', '63'), ('7649', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 21:59:35', '0', '新增CXD00000000695', '63'), ('7650', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 22:03:40', '0', '新增QTRK00000000697', '63'), ('7651', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 22:08:53', '0', '新增CGDD00000000700', '63'), ('7652', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 22:10:50', '0', '新增CGRK00000000701', '63'), ('7653', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-09 22:12:47', '0', '新增ZZD00000000699', '63'), ('7654', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:19:18', '0', '修改角色的按钮权限', '63'), ('7655', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:20:54', '0', '修改角色的按钮权限', '63'), ('7656', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:20:58', '0', '修改', '63'), ('7657', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:21:02', '0', '修改角色的按钮权限', '63'), ('7658', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:21:32', '0', '修改', '63'), ('7659', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:21:50', '0', '修改', '63'), ('7660', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:21:52', '0', '修改角色的按钮权限', '63'), ('7661', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-09 22:23:06', '0', '登录cg', '63'), ('7662', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:25:30', '0', '修改', '63'), ('7663', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:25:33', '0', '修改角色的按钮权限', '63'), ('7664', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:27:21', '0', '修改', '63'), ('7665', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-09 22:27:24', '0', '修改角色的按钮权限', '63'), ('7666', '147', '用户', '127.0.0.1/127.0.0.1', '2023-03-09 22:27:57', '0', '登录ckgl', '63'), ('7667', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-09 22:33:47', '0', '修改太阳花', '63'), ('7668', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-10 21:25:07', '0', '修改太阳花', '63'), ('7669', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-13 15:44:07', '0', '登录jsh', '63'), ('7670', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-13 15:44:30', '0', '修改', '63'), ('7671', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-13 15:51:11', '0', '登录jsh', '63'), ('7672', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-13 16:42:04', '0', '修改角色的按钮权限', '63'), ('7673', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-13 16:42:22', '0', '登录jsh', '63'), ('7674', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-13 16:45:52', '0', '登录jsh', '63'), ('7675', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-13 16:45:54', '0', '登录jsh', '63'), ('7676', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-13 16:47:06', '0', '登录jsh', '63'), ('7677', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-14 21:57:48', '0', '登录jsh', '63'), ('7678', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-14 23:34:43', '0', '登录jsh', '63'), ('7679', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-15 00:22:06', '0', '登录jsh', '63'), ('7680', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-16 16:45:07', '0', '登录jsh', '63'), ('7681', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-16 17:06:13', '0', '新增太阳花', '63'), ('7682', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-16 21:14:23', '0', '新增ZZD00000000767', '63'), ('7683', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-16 21:21:45', '0', '新增CXD00000000771', '63'), ('7684', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-17 11:32:57', '0', '登录jsh', '63'), ('7685', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-17 11:33:51', '0', '新增CGDD00000000782', '63'), ('7686', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-17 17:48:21', '0', '修改CGDD00000000782', '63'), ('7687', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-17 17:48:37', '0', '修改CGDD00000000782', '63'), ('7688', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-17 17:48:42', '0', '修改CGDD00000000782', '63'), ('7689', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 16:38:48', '0', '登录jsh', '63'), ('7690', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 18:36:39', '0', '新增CGDD00000000912', '63'), ('7691', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 18:36:51', '0', '删除[CGDD00000000912]', '63'), ('7692', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 19:31:16', '0', '新增CGDD00000000917', '63'), ('7693', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 19:45:36', '0', '登录cg', '63'), ('7694', '147', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 19:45:55', '0', '登录ckgl', '63'), ('7695', '146', '商家', '127.0.0.1/127.0.0.1', '2023-03-20 19:48:04', '0', '新增珠海隆升钢材科技有限公司', '63'), ('7696', '146', '商品', '127.0.0.1/127.0.0.1', '2023-03-20 19:50:08', '0', '新增不锈钢螺丝', '63'), ('7697', '146', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 19:51:34', '0', '新增CGDD00000000918', '63'), ('7698', '146', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 19:55:16', '0', '新增CGRK00000000919', '63'), ('7699', '147', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 20:04:39', '0', '新增QTCK00000000921', '63'), ('7700', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:08:03', '0', '登录jsh', '63'), ('7701', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:08:27', '0', '修改', '63'), ('7702', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:08:36', '0', '修改角色的按钮权限', '63'), ('7703', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:09:11', '0', '修改', '63'), ('7704', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:09:19', '0', '修改角色的按钮权限', '63'), ('7705', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:09:57', '0', '修改', '63'), ('7706', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:10:09', '0', '修改角色的按钮权限', '63'), ('7707', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:10:19', '0', '登录cg', '63'), ('7708', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:11:15', '0', '登录jsh', '63'), ('7709', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:11:27', '0', '登录cg', '63'), ('7710', '146', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 20:12:16', '0', '新增XSDD00000000928', '63'), ('7711', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:13:46', '0', '登录jsh', '63'), ('7712', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:14:12', '0', '修改', '63'), ('7713', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:14:15', '0', '修改角色的按钮权限', '63'), ('7714', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:14:48', '0', '修改', '63'), ('7715', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:14:51', '0', '修改角色的按钮权限', '63'), ('7716', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:15:21', '0', '新增', '63'), ('7717', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:15:21', '0', '新增', '63'), ('7718', '63', '角色', '127.0.0.1/127.0.0.1', '2023-03-20 20:15:28', '0', '修改销售', '63'), ('7719', '148', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:15:50', '0', '登录xs', '63'), ('7720', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:16:10', '0', '登录jsh', '63'), ('7721', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:17:21', '0', '修改', '63'), ('7722', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:17:32', '0', '修改角色的按钮权限', '63'), ('7723', '148', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:17:48', '0', '登录xs', '63'), ('7724', '148', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 20:19:06', '0', '新增XSDD00000000932', '63'), ('7725', '146', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:19:29', '0', '登录cg', '63'), ('7726', '146', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 20:20:56', '0', '新增CGDD00000000933', '63'), ('7727', '146', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 20:22:00', '0', '新增CGRK00000000935', '63'), ('7728', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:23:16', '0', '登录jsh', '63'), ('7729', '63', '角色', '127.0.0.1/127.0.0.1', '2023-03-20 20:23:57', '0', '新增研发', '63'), ('7730', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:24:34', '0', '新增', '63'), ('7731', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:24:39', '0', '修改角色的按钮权限', '63'), ('7732', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:25:30', '0', '登录jsh', '63'), ('7733', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:25:45', '0', '新增', '63'), ('7734', '63', '关联关系', '127.0.0.1/127.0.0.1', '2023-03-20 20:25:45', '0', '新增', '63'), ('7735', '149', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:25:48', '0', '登录yf', '63'), ('7736', '148', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:28:04', '0', '登录xs', '63'), ('7737', '147', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:29:17', '0', '登录ckgl', '63'), ('7738', '147', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 20:30:23', '0', '新增ZZD00000000936', '63'), ('7739', '148', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:36:16', '0', '登录xs', '63'), ('7740', '147', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 20:37:13', '0', '新增XSCK00000000938', '63'), ('7741', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-20 20:37:48', '0', '登录jsh', '63'), ('7742', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-20 22:52:32', '0', '修改支架', '63'), ('7743', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-20 22:52:39', '0', '修改电池', '63'), ('7744', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-20 22:52:51', '0', '修改电池', '63'), ('7745', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-20 22:52:58', '0', '修改支架', '63'), ('7746', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-20 22:53:09', '0', '修改太阳花', '63'), ('7747', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-20 23:38:27', '0', '修改XSDD00000000928', '63'), ('7748', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-21 00:04:00', '0', '登录jsh', '63'), ('7749', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-21 01:26:59', '0', '新增XSDD00000001040', '63'), ('7750', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-21 01:32:20', '0', '修改XSDD00000001040', '63'), ('7751', '63', '系统配置', '127.0.0.1/127.0.0.1', '2023-03-21 15:53:02', '0', '修改珠海城电科技有限公司', '63'), ('7752', '63', '系统配置', '127.0.0.1/127.0.0.1', '2023-03-21 15:53:43', '0', '修改珠海城电科技有限公司', '63'), ('7753', '63', '商品', '127.0.0.1/127.0.0.1', '2023-03-21 17:35:51', '0', '修改不锈钢螺丝', '63'), ('7754', '63', '用户', '127.0.0.1/127.0.0.1', '2023-03-22 11:18:12', '0', '登录jsh', '63'), ('7755', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-22 11:29:33', '0', '新增CGDD2023038100010', '63'), ('7756', '63', '单据', '127.0.0.1/127.0.0.1', '2023-03-23 12:45:36', '0', '新增CGDD2023038200001', '63');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_material`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material`;
CREATE TABLE `jsh_material` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_id` bigint(20) DEFAULT NULL COMMENT '产品类型id',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `mfrs` varchar(50) DEFAULT NULL COMMENT '制造商',
  `model` varchar(50) DEFAULT NULL COMMENT '型号',
  `standard` varchar(50) DEFAULT NULL COMMENT '规格',
  `color` varchar(50) DEFAULT NULL COMMENT '颜色',
  `unit` varchar(50) DEFAULT NULL COMMENT '单位-单个',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `img_name` varchar(500) DEFAULT NULL COMMENT '图片名称',
  `unit_id` bigint(20) DEFAULT NULL COMMENT '计量单位Id',
  `expiry_num` int(10) DEFAULT NULL COMMENT '保质期天数',
  `weight` decimal(24,6) DEFAULT NULL COMMENT '基础重量(kg)',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用 0-禁用  1-启用',
  `other_field1` varchar(50) DEFAULT NULL COMMENT '自定义1',
  `other_field2` varchar(50) DEFAULT NULL COMMENT '自定义2',
  `other_field3` varchar(50) DEFAULT NULL COMMENT '自定义3',
  `enable_serial_number` varchar(1) DEFAULT '0' COMMENT '是否开启序列号，0否，1是',
  `enable_batch_number` varchar(1) DEFAULT '0' COMMENT '是否开启批号，0否，1是',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `enableSerialNumber` varchar(1) DEFAULT '0' COMMENT '是否开启序列号，0否，1是',
  PRIMARY KEY (`id`),
  KEY `FK675951272AB6672C` (`category_id`),
  KEY `UnitId` (`unit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=627 DEFAULT CHARSET=utf8 COMMENT='产品表';

-- ----------------------------
--  Records of `jsh_material`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material` VALUES ('568', '17', '商品1', '制1', 'sp1', '', '', '个', '', null, null, null, null, b'1', '', '', '', '0', '0', '63', '1', '0'), ('569', '17', '商品2', '', 'sp2', '', '', '只', '', null, null, null, null, b'1', '', '', '', '0', '0', '63', '1', '0'), ('570', '17', '商品3', '', 'sp3', '', '', '个', '', null, null, null, null, b'1', '', '', '', '0', '0', '63', '1', '0'), ('577', null, '商品8', '', 'sp8', '', '', '', '', null, '15', null, null, b'1', '', '', '', '0', '0', '63', '1', '0'), ('579', '21', '商品17', '', 'sp17', '', '', '', '', null, '15', null, null, b'1', '', '', '', '0', '0', '63', '1', '0'), ('586', '17', '序列号商品测试', '', 'xlh123', '', '', '个', '', null, null, null, null, b'1', '', '', '', '1', '0', '63', '1', '0'), ('587', '17', '商品test1', '南通中远', '', 'test1', '', '个', '', null, null, null, null, b'1', '', '', '', '0', '0', '63', '1', '0'), ('588', '21', '商品200', 'fafda', 'weqwe', '300ml', '红色', '个', 'aaaabbbbb', null, null, null, null, b'1', '', '', '', '0', '0', '63', '1', '0'), ('619', null, '衣服', null, null, null, null, '件', null, '', null, null, null, b'1', null, null, null, '0', '0', '63', '1', '0'), ('620', null, '马克杯', null, null, null, '红色', '个', null, '', null, null, null, b'1', null, null, null, '0', '0', '63', '1', '0'), ('621', null, '马克杯2', null, null, null, null, '只', null, '', null, null, null, b'1', null, null, null, '0', '0', '63', '1', '0'), ('622', '17', '电池', null, '', '', '红色', '个', null, '', null, null, '1.000000', b'1', null, null, null, '0', '0', '63', '0', '0'), ('623', '17', '支架', null, null, null, null, '个', null, '', null, null, null, b'1', null, null, null, '0', '0', '63', '0', '0'), ('624', '23', '太阳花', null, null, null, null, '个', null, '', null, null, null, b'1', null, null, null, '0', '0', '63', '0', '0'), ('625', '23', '太阳花', null, 'T1', '1.5KW', null, '个', null, '', null, null, null, b'1', null, null, null, '0', '0', '63', '0', '0'), ('626', null, '不锈钢螺丝', null, null, '4.8*38', null, '个', null, '', null, null, null, b'1', null, null, null, '0', '0', '63', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_material_attribute`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_attribute`;
CREATE TABLE `jsh_material_attribute` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(50) DEFAULT NULL COMMENT '属性名',
  `attribute_value` varchar(500) DEFAULT NULL COMMENT '属性值',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='产品属性表';

-- ----------------------------
--  Records of `jsh_material_attribute`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_attribute` VALUES ('1', '多颜色', '红色|橙色|黄色|绿色|蓝色|紫色', '63', '0'), ('2', '多尺寸', 'S|M|L|XL|XXL|XXXL', '63', '0'), ('3', '自定义1', '小米|华为', '63', '0'), ('4', '自定义2', null, '63', '0'), ('5', '自定义3', null, '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_material_category`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_category`;
CREATE TABLE `jsh_material_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `category_level` smallint(6) DEFAULT NULL COMMENT '等级',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '上级id',
  `sort` varchar(10) DEFAULT NULL COMMENT '显示顺序',
  `serial_no` varchar(100) DEFAULT NULL COMMENT '编号',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK3EE7F725237A77D8` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='产品类型表';

-- ----------------------------
--  Records of `jsh_material_category`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_category` VALUES ('17', '原料', null, null, '11', 'S10', 'eee', '2019-04-10 22:18:12', '2023-03-09 21:55:17', '63', '0'), ('21', '大太阳花', null, '17', '1', 'S1001', '', '2020-07-20 23:08:44', '2023-03-09 21:56:15', '63', '1'), ('22', '小太阳花', null, '17', '2', 'S1002', null, '2023-03-09 18:19:02', '2023-03-09 21:56:15', '63', '1'), ('23', '成品', null, null, null, 'CP', null, '2023-03-09 21:54:57', '2023-03-09 21:54:57', '63', '0'), ('24', '太阳花', null, '23', null, 'SF', null, '2023-03-09 21:55:33', '2023-03-09 21:55:37', '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_material_current_stock`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_current_stock`;
CREATE TABLE `jsh_material_current_stock` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '产品id',
  `depot_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
  `current_number` decimal(24,6) DEFAULT NULL COMMENT '当前库存数量',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品当前库存';

-- ----------------------------
--  Records of `jsh_material_current_stock`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_current_stock` VALUES ('19', '588', '14', '0.000000', '63', '0'), ('20', '568', '14', '0.000000', '63', '0'), ('21', '568', '15', '0.000000', '63', '0'), ('22', '570', '14', '0.000000', '63', '0'), ('23', '619', '14', '0.000000', '63', '0'), ('24', '619', '15', '0.000000', '63', '0'), ('25', '619', '17', '0.000000', '63', '0'), ('26', '621', '14', '0.000000', '63', '0'), ('27', '620', '14', '0.000000', '63', '0'), ('28', '620', '15', '0.000000', '63', '0'), ('29', '620', '17', '0.000000', '63', '0'), ('30', '621', '15', '0.000000', '63', '0'), ('31', '621', '17', '0.000000', '63', '0'), ('32', '622', '14', '104.000000', '63', '0'), ('33', '622', '15', '0.000000', '63', '0'), ('34', '622', '17', '0.000000', '63', '0'), ('35', '623', '14', '98.000000', '63', '0'), ('36', '623', '15', '0.000000', '63', '0'), ('37', '623', '17', '0.000000', '63', '0'), ('38', '624', '14', '1.000000', '63', '0'), ('39', '624', '15', '0.000000', '63', '0'), ('40', '624', '17', '0.000000', '63', '0'), ('41', '625', '14', '0.000000', '63', '0'), ('42', '626', '17', '500.000000', '63', '0'), ('43', '625', '15', '0.000000', '63', '0'), ('44', '625', '17', '0.000000', '63', '0'), ('45', '626', '14', '0.000000', '63', '0'), ('46', '626', '15', '0.000000', '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_material_extend`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_extend`;
CREATE TABLE `jsh_material_extend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `bar_code` varchar(50) DEFAULT NULL COMMENT '商品条码',
  `commodity_unit` varchar(50) DEFAULT NULL COMMENT '商品单位',
  `sku` varchar(50) DEFAULT NULL COMMENT '多属性',
  `purchase_decimal` decimal(24,6) DEFAULT NULL COMMENT '采购价格',
  `commodity_decimal` decimal(24,6) DEFAULT NULL COMMENT '零售价格',
  `wholesale_decimal` decimal(24,6) DEFAULT NULL COMMENT '销售价格',
  `low_decimal` decimal(24,6) DEFAULT NULL COMMENT '最低售价',
  `default_flag` varchar(1) DEFAULT '1' COMMENT '是否为默认单位，1是，0否',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_serial` varchar(50) DEFAULT NULL COMMENT '创建人编码',
  `update_serial` varchar(50) DEFAULT NULL COMMENT '更新人编码',
  `update_time` bigint(20) DEFAULT NULL COMMENT '更新时间戳',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_Flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品价格扩展';

-- ----------------------------
--  Records of `jsh_material_extend`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_extend` VALUES ('1', '587', '1000', '个', null, '11.000000', '22.000000', '22.000000', '22.000000', '1', '2020-02-20 23:22:03', 'jsh', 'jsh', '1595263657135', '63', '1'), ('2', '568', '1001', '个', null, '11.000000', '15.000000', '15.000000', '15.000000', '1', '2020-02-20 23:44:57', 'jsh', 'jsh', '1595265439418', '63', '1'), ('3', '569', '1002', '只', null, '10.000000', '15.000000', '15.000000', '13.000000', '1', '2020-02-20 23:45:15', 'jsh', 'jsh', '1582213514731', '63', '1'), ('4', '570', '1003', '个', null, '8.000000', '15.000000', '14.000000', '13.000000', '1', '2020-02-20 23:45:37', 'jsh', 'jsh', '1587657604430', '63', '1'), ('5', '577', '1004', '个', null, '10.000000', '20.000000', '20.000000', '20.000000', '1', '2020-02-20 23:46:36', 'jsh', 'jsh', '1582213596494', '63', '1'), ('6', '577', '1005', '箱', null, '120.000000', '240.000000', '240.000000', '240.000000', '0', '2020-02-20 23:46:36', 'jsh', 'jsh', '1582213596497', '63', '1'), ('7', '579', '1006', '个', null, '20.000000', '30.000000', '30.000000', '30.000000', '1', '2020-02-20 23:47:04', 'jsh', 'jsh', '1595264270458', '63', '1'), ('8', '579', '1007', '箱', null, '240.000000', '360.000000', '360.000000', '360.000000', '0', '2020-02-20 23:47:04', 'jsh', 'jsh', '1595264270466', '63', '1'), ('9', '586', '1008', '个', null, '12.000000', '15.000000', '15.000000', '15.000000', '1', '2020-02-20 23:47:23', 'jsh', 'jsh', '1595254981896', '63', '1'), ('10', '588', '1009', '个', null, '11.000000', '22.000000', '22.000000', '22.000000', '1', '2020-07-21 00:58:15', 'jsh', 'jsh', '1614699799073', '63', '1'), ('36', '619', '1014', '件', '橙色,M', '12.000000', '15.000000', '14.000000', null, '1', '2021-07-28 01:00:20', 'jsh', 'jsh', '1627405220316', '63', '1'), ('37', '619', '1015', '件', '橙色,L', '12.000000', '15.000000', '14.000000', null, '0', '2021-07-28 01:00:20', 'jsh', 'jsh', '1627405220327', '63', '1'), ('38', '619', '1016', '件', '绿色,M', '12.000000', '15.000000', '14.000000', null, '0', '2021-07-28 01:00:20', 'jsh', 'jsh', '1627405220336', '63', '1'), ('39', '619', '1017', '件', '绿色,L', '12.000000', '15.000000', '14.000000', null, '0', '2021-07-28 01:00:20', 'jsh', 'jsh', '1627405220346', '63', '1'), ('40', '620', '1018', '个', '1', '20.000000', null, null, null, '1', '2023-03-06 18:05:02', 'jsh', 'jsh', '1678111605856', '63', '1'), ('41', '621', '1019', '只', '', null, null, null, null, '1', '2023-03-06 18:06:01', 'jsh', 'jsh', '1678111664659', '63', '1'), ('42', '622', '1022', '个', '', '10.000000', '0.000000', '0.000000', '0.000000', '1', '2023-03-09 18:21:52', 'jsh', 'jsh', '1679546735504', '63', '0'), ('43', '622', '1023', '个', '', '2.000000', '2.000000', '2.000000', '2.000000', '0', '2023-03-09 18:21:52', 'jsh', 'jsh', '1678357312173', '63', '1'), ('44', '622', '1023', '个', '', null, null, null, null, '0', '2023-03-09 21:36:27', 'jsh', 'jsh', '1678368987560', '63', '1'), ('45', '623', '1023', '个', '', '8.000000', '0.000000', '0.000000', '0.000000', '1', '2023-03-09 21:47:50', 'jsh', 'jsh', '1679323978191', '63', '0'), ('46', '624', '1027', '个', '', null, null, null, null, '1', '2023-03-09 21:54:12', 'jsh', 'jsh', '1678454707098', '63', '0'), ('47', '624', '1028', '个', '', null, null, null, null, '0', '2023-03-10 21:25:07', 'jsh', 'jsh', '1678454707127', '63', '0'), ('48', '625', '1024', '个', '', null, null, '900.000000', null, '1', '2023-03-16 17:06:13', 'jsh', 'jsh', '1679333539667', '63', '0'), ('49', '626', '100021', '个', '', '0.900000', null, null, null, '1', '2023-03-20 19:50:08', 'cg', 'jsh', '1679391351152', '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_material_initial_stock`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_initial_stock`;
CREATE TABLE `jsh_material_initial_stock` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '产品id',
  `depot_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
  `number` decimal(24,6) DEFAULT NULL COMMENT '初始库存数量',
  `low_safe_stock` decimal(24,6) DEFAULT NULL COMMENT '最低库存数量',
  `high_safe_stock` decimal(24,6) DEFAULT NULL COMMENT '最高库存数量',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品初始库存';

-- ----------------------------
--  Records of `jsh_material_initial_stock`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_initial_stock` VALUES ('205', '620', '14', '0.000000', null, null, '63', '0'), ('206', '620', '15', '0.000000', null, null, '63', '0'), ('207', '620', '17', '0.000000', null, null, '63', '0'), ('208', '621', '14', '0.000000', null, null, '63', '0'), ('209', '621', '15', '0.000000', null, null, '63', '0'), ('210', '621', '17', '0.000000', null, null, '63', '0'), ('232', '624', '14', '0.000000', null, null, '63', '0'), ('233', '624', '15', '0.000000', null, null, '63', '0'), ('234', '624', '17', '0.000000', null, null, '63', '0'), ('241', '622', '14', '0.000000', null, null, '63', '0'), ('242', '622', '15', '0.000000', null, null, '63', '0'), ('243', '622', '17', '0.000000', null, null, '63', '0'), ('244', '623', '14', '0.000000', null, null, '63', '0'), ('245', '623', '15', '0.000000', null, null, '63', '0'), ('246', '623', '17', '0.000000', null, null, '63', '0'), ('247', '625', '14', '0.000000', null, null, '63', '0'), ('248', '625', '15', '0.000000', null, null, '63', '0'), ('249', '625', '17', '0.000000', null, null, '63', '0'), ('250', '626', '14', '0.000000', null, null, '63', '0'), ('251', '626', '15', '0.000000', null, null, '63', '0'), ('252', '626', '17', '0.000000', null, null, '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_material_property`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_property`;
CREATE TABLE `jsh_material_property` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `native_name` varchar(50) DEFAULT NULL COMMENT '原始名称',
  `enabled` bit(1) DEFAULT NULL COMMENT '是否启用',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `another_name` varchar(50) DEFAULT NULL COMMENT '别名',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='产品扩展字段表';

-- ----------------------------
--  Records of `jsh_material_property`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_property` VALUES ('1', '制造商', b'1', '01', '制造商', '0'), ('2', '自定义1', b'1', '02', '自定义1', '0'), ('3', '自定义2', b'1', '03', '自定义2', '0'), ('4', '自定义3', b'1', '04', '自定义3', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_material_stock`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_stock`;
CREATE TABLE `jsh_material_stock` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '产品id',
  `depot_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
  `number` decimal(24,6) DEFAULT NULL COMMENT '初始库存数量',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_fag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品初始库存';

-- ----------------------------
--  Table structure for `jsh_msg`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_msg`;
CREATE TABLE `jsh_msg` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `msg_title` varchar(100) DEFAULT NULL COMMENT '消息标题',
  `msg_content` varchar(500) DEFAULT NULL COMMENT '消息内容',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `type` varchar(20) DEFAULT NULL COMMENT '消息类型',
  `user_id` bigint(20) DEFAULT NULL COMMENT '接收人id',
  `status` varchar(1) DEFAULT NULL COMMENT '状态，1未读 2已读',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_Flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='消息表';

-- ----------------------------
--  Records of `jsh_msg`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_msg` VALUES ('2', '标题1', '内容1', '2019-09-10 00:11:39', '类型1', '63', '2', '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_orga_user_rel`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_orga_user_rel`;
CREATE TABLE `jsh_orga_user_rel` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `orga_id` bigint(20) NOT NULL COMMENT '机构id',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `user_blng_orga_dspl_seq` varchar(20) DEFAULT NULL COMMENT '用户在所属机构中显示顺序',
  `delete_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新人',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机构用户关系表';

-- ----------------------------
--  Table structure for `jsh_organization`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_organization`;
CREATE TABLE `jsh_organization` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `org_no` varchar(20) DEFAULT NULL COMMENT '机构编号',
  `org_abr` varchar(20) DEFAULT NULL COMMENT '机构简称',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父机构id',
  `sort` varchar(20) DEFAULT NULL COMMENT '机构显示顺序',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='机构表';

-- ----------------------------
--  Records of `jsh_organization`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_organization` VALUES ('1', '01', '根机构', '2', '-1', '1', '根机构，初始化存在', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `jsh_person`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_person`;
CREATE TABLE `jsh_person` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='经手人表';

-- ----------------------------
--  Records of `jsh_person`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_person` VALUES ('14', '业务员', '小李', b'1', null, '63', '0'), ('15', '仓管员', '小军', b'1', null, '63', '0'), ('16', '财务员', '小夏', b'1', null, '63', '0'), ('17', '财务员', '小曹', b'1', null, '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_platform_config`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_platform_config`;
CREATE TABLE `jsh_platform_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `platform_key` varchar(100) DEFAULT NULL COMMENT '关键词',
  `platform_key_info` varchar(100) DEFAULT NULL COMMENT '关键词名称',
  `platform_value` varchar(200) DEFAULT NULL COMMENT '值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='平台参数';

-- ----------------------------
--  Records of `jsh_platform_config`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_platform_config` VALUES ('1', 'platform_name', '平台名称', 'ERP系统'), ('2', 'activation_code', '激活码', null), ('3', 'platform_url', '官方网站', 'http://www.localhost.com/'), ('4', 'bill_print_flag', '三联打印启用标记', '0'), ('5', 'bill_print_url', '三联打印地址', ''), ('6', 'pay_fee_url', '租户续费地址', ''), ('7', 'register_flag', '注册启用标记', '0'), ('8', 'app_activation_code', '手机端激活码', ''), ('9', 'send_workflow_url', '发起流程地址', '');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_role`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_role`;
CREATE TABLE `jsh_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `type` varchar(50) DEFAULT NULL COMMENT '类型',
  `price_limit` varchar(50) DEFAULT NULL COMMENT '价格屏蔽 1-屏蔽采购价 2-屏蔽零售价 3-屏蔽销售价',
  `value` varchar(200) DEFAULT NULL COMMENT '值',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
--  Records of `jsh_role`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_role` VALUES ('4', '管理员', '全部数据', null, null, null, b'1', null, null, '0'), ('10', '租户', '全部数据', null, null, '', b'1', null, null, '0'), ('16', '销售经理', '全部数据', null, null, '', b'1', null, '63', '0'), ('17', '销售', '个人数据', null, null, '', b'1', null, '63', '0'), ('21', '采购', '全部数据', null, null, null, b'1', null, '63', '0'), ('22', '仓库管理员', '全部数据', '1,2,3', null, null, b'1', null, '63', '0'), ('23', '研发', '本机构数据', '', null, null, b'1', null, '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_sequence`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_sequence`;
CREATE TABLE `jsh_sequence` (
  `seq_name` varchar(50) NOT NULL COMMENT '序列名称',
  `min_value` bigint(20) NOT NULL COMMENT '最小值',
  `max_value` bigint(20) NOT NULL COMMENT '最大值',
  `current_val` bigint(20) NOT NULL COMMENT '当前值',
  `increment_val` int(11) NOT NULL DEFAULT '1' COMMENT '增长步数',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`seq_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='单据编号表';

-- ----------------------------
--  Records of `jsh_sequence`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_sequence` VALUES ('CGDD20230380', '0', '9223372036854775807', '7', '1', null), ('CGDD20230381', '0', '9223372036854775807', '10', '1', null), ('CGDD20230382', '0', '9223372036854775807', '1', '1', null), ('CGRK20230323', '0', '9223372036854775807', '1', '1', null), ('depot_number_seq', '1', '999999999999999999', '1050', '1', '单据编号sequence'), ('XSDD20230323', '0', '9223372036854775807', '3', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `jsh_serial_number`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_serial_number`;
CREATE TABLE `jsh_serial_number` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '产品表id',
  `depot_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
  `serial_number` varchar(64) DEFAULT NULL COMMENT '序列号',
  `is_sell` varchar(1) DEFAULT '0' COMMENT '是否卖出，0未卖出，1卖出',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新人',
  `in_bill_no` varchar(50) DEFAULT NULL COMMENT '入库单号',
  `out_bill_no` varchar(50) DEFAULT NULL COMMENT '出库单号',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8 COMMENT='序列号表';

-- ----------------------------
--  Records of `jsh_serial_number`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_serial_number` VALUES ('105', '586', '14', '12312323423223', '0', 'abab', '0', '2019-12-28 12:14:39', '63', '2020-07-21 00:30:32', '63', null, null, '63'), ('108', '586', '14', '3215952626621201', '0', '', '0', '2020-07-21 00:31:02', '63', '2020-07-21 00:31:02', '63', null, null, '63'), ('109', '586', '14', '3215952626621202', '0', '', '0', '2020-07-21 00:31:02', '63', '2020-07-21 00:31:02', '63', null, null, '63');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_supplier`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_supplier`;
CREATE TABLE `jsh_supplier` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `supplier` varchar(255) NOT NULL COMMENT '供应商名称',
  `contacts` varchar(100) DEFAULT NULL COMMENT '联系人',
  `phone_num` varchar(30) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮箱',
  `description` varchar(500) DEFAULT NULL COMMENT '备注',
  `isystem` tinyint(4) DEFAULT NULL COMMENT '是否系统自带 0==系统 1==非系统',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `advance_in` decimal(24,6) DEFAULT '0.000000' COMMENT '预收款',
  `begin_need_get` decimal(24,6) DEFAULT NULL COMMENT '期初应收',
  `begin_need_pay` decimal(24,6) DEFAULT NULL COMMENT '期初应付',
  `all_need_get` decimal(24,6) DEFAULT NULL COMMENT '累计应收',
  `all_need_pay` decimal(24,6) DEFAULT NULL COMMENT '累计应付',
  `fax` varchar(30) DEFAULT NULL COMMENT '传真',
  `telephone` varchar(30) DEFAULT NULL COMMENT '手机',
  `address` varchar(50) DEFAULT NULL COMMENT '地址',
  `tax_num` varchar(50) DEFAULT NULL COMMENT '纳税人识别号',
  `bank_name` varchar(50) DEFAULT NULL COMMENT '开户行',
  `account_number` varchar(50) DEFAULT NULL COMMENT '账号',
  `tax_rate` decimal(24,6) DEFAULT NULL COMMENT '税率',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COMMENT='供应商/客户信息表';

-- ----------------------------
--  Records of `jsh_supplier`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_supplier` VALUES ('57', '供应商1', '小军', '12345678', '', '', null, '供应商', b'1', '0.000000', '0.000000', '0.000000', '0.000000', '4.000000', '', '15000000000', '地址1', '', '', '', '12.000000', null, '63', '0'), ('58', '客户1', '小李', '12345678', '', '', null, '客户', b'1', '0.000000', '0.000000', '0.000000', '-100.000000', null, '', '', '', '', '', '', '12.000000', null, '63', '0'), ('59', '客户2', '小陈', '', '', '', null, '客户', b'1', '0.000000', '0.000000', '0.000000', '0.000000', null, '', '', '', '', '', '', null, null, '63', '0'), ('60', '12312666', '小曹', '', '', '', null, '会员', b'1', '890.000000', '0.000000', '0.000000', null, null, '', '13000000000', '', '', '', '', null, null, '63', '0'), ('68', '供应商3', '晓丽', '12345678', '', 'fasdfadf', null, '供应商', b'1', '0.000000', '0.000000', '0.000000', '0.000000', '-35.000000', '', '13000000000', 'aaaa', '1341324', '', '', '13.000000', null, '63', '0'), ('71', '客户3', '小周', '', '', '', null, '客户', b'1', '0.000000', '0.000000', '0.000000', '0.000000', null, '', '', '', '', '', '', null, null, '63', '0'), ('74', '供应商5', '小季', '77779999', '', '', null, '供应商', b'1', '0.000000', '0.000000', '5.000000', '0.000000', '5.000000', '', '15806283912', '', '', '', '', '3.000000', null, '63', '0'), ('75', '珠海隆升钢材科技有限公司', '李小姐', null, null, null, null, '供应商', b'1', '0.000000', null, null, null, null, null, '1556666666', null, null, null, null, null, null, '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_system_config`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_system_config`;
CREATE TABLE `jsh_system_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `company_name` varchar(50) DEFAULT NULL COMMENT '公司名称',
  `company_contacts` varchar(20) DEFAULT NULL COMMENT '公司联系人',
  `company_address` varchar(50) DEFAULT NULL COMMENT '公司地址',
  `company_tel` varchar(20) DEFAULT NULL COMMENT '公司电话',
  `company_fax` varchar(20) DEFAULT NULL COMMENT '公司传真',
  `company_post_code` varchar(20) DEFAULT NULL COMMENT '公司邮编',
  `sale_agreement` varchar(500) DEFAULT NULL COMMENT '销售协议',
  `depot_flag` varchar(1) DEFAULT '0' COMMENT '仓库启用标记，0未启用，1启用',
  `customer_flag` varchar(1) DEFAULT '0' COMMENT '客户启用标记，0未启用，1启用',
  `minus_stock_flag` varchar(1) DEFAULT '0' COMMENT '负库存启用标记，0未启用，1启用',
  `purchase_by_sale_flag` varchar(1) DEFAULT '0' COMMENT '以销定购启用标记，0未启用，1启用',
  `multi_level_approval_flag` varchar(1) DEFAULT '0' COMMENT '多级审核启用标记，0未启用，1启用',
  `multi_bill_type` varchar(200) DEFAULT NULL COMMENT '流程类型，可多选',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统参数';

-- ----------------------------
--  Records of `jsh_system_config`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_system_config` VALUES ('11', '珠海城电科技有限公司', '小李', '珠海市高新区唐家湾镇新港路99号1栋7层702-1室', '12345678', null, null, '注：本单为我公司与客户约定账期内结款的依据，由客户或其单位员工签字生效，并承担法律责任。', '0', '0', '1', '0', '0', '', '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_tenant`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_tenant`;
CREATE TABLE `jsh_tenant` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `login_name` varchar(255) DEFAULT NULL COMMENT '登录名',
  `user_num_limit` int(11) DEFAULT NULL COMMENT '用户数量限制',
  `type` varchar(1) DEFAULT '0' COMMENT '租户类型，0免费租户，1付费租户',
  `enabled` bit(1) DEFAULT b'1' COMMENT '启用 0-禁用  1-启用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='租户';

-- ----------------------------
--  Records of `jsh_tenant`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_tenant` VALUES ('13', '63', 'jsh', '2000', '1', b'1', null, '2099-12-30 22:00:00', null);
COMMIT;

-- ----------------------------
--  Table structure for `jsh_unit`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_unit`;
CREATE TABLE `jsh_unit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称，支持多单位',
  `basic_unit` varchar(50) DEFAULT NULL COMMENT '基础单位',
  `other_unit` varchar(50) DEFAULT NULL COMMENT '副单位',
  `other_unit_two` varchar(50) DEFAULT NULL COMMENT '副单位2',
  `other_unit_three` varchar(50) DEFAULT NULL COMMENT '副单位3',
  `ratio` int(11) DEFAULT NULL COMMENT '比例',
  `ratio_two` int(11) DEFAULT NULL COMMENT '比例2',
  `ratio_three` int(11) DEFAULT NULL COMMENT '比例3',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='多单位表';

-- ----------------------------
--  Records of `jsh_unit`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_unit` VALUES ('15', '个/(箱=12个)', '个', '箱', null, null, '12', null, null, b'1', '63', '0'), ('19', '个/(盒=15个)', '个', '盒', null, null, '15', null, null, b'1', '63', '0'), ('20', '盒/(箱=8盒)', '盒', '箱', null, null, '8', null, null, b'1', '63', '0'), ('21', '瓶/(箱=12瓶)', '瓶', '箱', null, null, '12', null, null, b'1', '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_user`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_user`;
CREATE TABLE `jsh_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(255) NOT NULL COMMENT '用户姓名--例如张三',
  `login_name` varchar(255) NOT NULL COMMENT '登录用户名',
  `password` varchar(50) DEFAULT NULL COMMENT '登陆密码',
  `leader_flag` varchar(1) DEFAULT '0' COMMENT '是否经理，0否，1是',
  `position` varchar(200) DEFAULT NULL COMMENT '职位',
  `department` varchar(255) DEFAULT NULL COMMENT '所属部门',
  `email` varchar(100) DEFAULT NULL COMMENT '电子邮箱',
  `phonenum` varchar(100) DEFAULT NULL COMMENT '手机号码',
  `ismanager` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否为管理者 0==管理者 1==员工',
  `isystem` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否系统自带数据 ',
  `Status` tinyint(4) DEFAULT '0' COMMENT '状态，0：正常，1：删除，2封禁',
  `description` varchar(500) DEFAULT NULL COMMENT '用户描述信息',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
--  Records of `jsh_user`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_user` VALUES ('63', '系统管理员', 'jsh', 'e10adc3949ba59abbe56e057f20f883e', '0', '主管', null, '', '', '1', '1', '0', '', null, '63'), ('120', '管理员', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '0', null, null, null, null, '1', '0', '0', null, null, '0'), ('131', 'test123', 'test123', 'e10adc3949ba59abbe56e057f20f883e', '0', '总监', null, '7777777@qq.com', '', '1', '0', '0', '', null, '63'), ('146', '采购员', 'cg', 'e10adc3949ba59abbe56e057f20f883e', '0', null, null, null, null, '1', '0', '0', null, null, '63'), ('147', '仓库管理员', 'ckgl', 'e10adc3949ba59abbe56e057f20f883e', '0', null, null, null, null, '1', '0', '0', null, null, '63'), ('148', '销售人员', 'xs', 'e10adc3949ba59abbe56e057f20f883e', '0', null, null, null, null, '1', '0', '0', null, null, '63'), ('149', '研发人员', 'yf', 'e10adc3949ba59abbe56e057f20f883e', '0', null, null, null, null, '1', '0', '0', null, null, '63');
COMMIT;

-- ----------------------------
--  Table structure for `jsh_user_business`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_user_business`;
CREATE TABLE `jsh_user_business` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类别',
  `key_id` varchar(50) DEFAULT NULL COMMENT '主id',
  `value` varchar(10000) DEFAULT NULL COMMENT '值',
  `btn_str` varchar(2000) DEFAULT NULL COMMENT '按钮权限',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 COMMENT='用户/角色/模块关系表';

-- ----------------------------
--  Records of `jsh_user_business`
-- ----------------------------
BEGIN;
INSERT INTO `jsh_user_business` VALUES ('5', 'RoleFunctions', '4', '[210][225][211][241][32][33][199][242][38][41][200][201][239][202][40][232][233][197][44][203][204][205][206][212][246][207][208][209][226][227][228][229][59][235][237][244][22][21][23][220][240][247][25][24][217][218][26][194][195][31][13][1][14][243][15][234][16][18][236][245][248][198][258][260][261]', '[{\"funId\":13,\"btnStr\":\"1\"},{\"funId\":14,\"btnStr\":\"1\"},{\"funId\":243,\"btnStr\":\"1\"},{\"funId\":234,\"btnStr\":\"1\"},{\"funId\":16,\"btnStr\":\"1\"},{\"funId\":18,\"btnStr\":\"1\"},{\"funId\":236,\"btnStr\":\"1\"},{\"funId\":245,\"btnStr\":\"1\"},{\"funId\":22,\"btnStr\":\"1\"},{\"funId\":23,\"btnStr\":\"1\"},{\"funId\":220,\"btnStr\":\"1\"},{\"funId\":240,\"btnStr\":\"1\"},{\"funId\":247,\"btnStr\":\"1\"},{\"funId\":25,\"btnStr\":\"1\"},{\"funId\":217,\"btnStr\":\"1\"},{\"funId\":218,\"btnStr\":\"1\"},{\"funId\":26,\"btnStr\":\"1\"},{\"funId\":194,\"btnStr\":\"1\"},{\"funId\":195,\"btnStr\":\"1\"},{\"funId\":31,\"btnStr\":\"1\"},{\"funId\":241,\"btnStr\":\"1,2,7\"},{\"funId\":33,\"btnStr\":\"1,2,7\"},{\"funId\":199,\"btnStr\":\"1,2,7\"},{\"funId\":242,\"btnStr\":\"1,2,7\"},{\"funId\":41,\"btnStr\":\"1,2,7\"},{\"funId\":200,\"btnStr\":\"1,2,7\"},{\"funId\":210,\"btnStr\":\"1,2,7\"},{\"funId\":211,\"btnStr\":\"1,2,7\"},{\"funId\":197,\"btnStr\":\"1,7,2\"},{\"funId\":203,\"btnStr\":\"1,7,2\"},{\"funId\":204,\"btnStr\":\"1,7,2\"},{\"funId\":205,\"btnStr\":\"1,7,2\"},{\"funId\":206,\"btnStr\":\"1,2,7\"},{\"funId\":212,\"btnStr\":\"1,7,2\"},{\"funId\":201,\"btnStr\":\"1,2,7\"},{\"funId\":202,\"btnStr\":\"1,2,7\"},{\"funId\":40,\"btnStr\":\"1,2,7\"},{\"funId\":232,\"btnStr\":\"1,2,7\"},{\"funId\":233,\"btnStr\":\"1,2,7\"},{\"funId\":261,\"btnStr\":\"1\"}]', null, '0'), ('6', 'RoleFunctions', '5', '[22][23][25][26][194][195][31][33][200][201][41][199][202]', null, null, '0'), ('7', 'RoleFunctions', '6', '[22][23][220][240][25][217][218][26][194][195][31][59][207][208][209][226][227][228][229][235][237][210][211][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212]', '[{\"funId\":\"33\",\"btnStr\":\"4\"}]', null, '0'), ('9', 'RoleFunctions', '7', '[168][13][12][16][14][15][189][18][19][132]', null, null, '0'), ('10', 'RoleFunctions', '8', '[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187][247]', null, null, '0'), ('11', 'RoleFunctions', '9', '[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187][188]', null, null, '0'), ('12', 'UserRole', '1', '[5]', null, null, '0'), ('13', 'UserRole', '2', '[6][7]', null, null, '0'), ('14', 'UserDepot', '2', '[1][2][6][7]', null, null, '0'), ('15', 'UserDepot', '1', '[1][2][5][6][7][10][12][14][15][17]', null, null, '0'), ('16', 'UserRole', '63', '[10]', null, '63', '0'), ('18', 'UserDepot', '63', '[14][15]', null, '63', '0'), ('19', 'UserDepot', '5', '[6][45][46][50]', null, null, '0'), ('20', 'UserRole', '5', '[5]', null, null, '0'), ('21', 'UserRole', '64', '[13]', null, null, '0'), ('22', 'UserDepot', '64', '[1]', null, null, '0'), ('23', 'UserRole', '65', '[5]', null, null, '0'), ('24', 'UserDepot', '65', '[1]', null, null, '0'), ('25', 'UserCustomer', '64', '[5][2]', null, null, '0'), ('26', 'UserCustomer', '65', '[6]', null, null, '0'), ('27', 'UserCustomer', '63', '[58]', null, '63', '0'), ('28', 'UserDepot', '96', '[7]', null, null, '0'), ('29', 'UserRole', '96', '[6]', null, null, '0'), ('30', 'UserRole', '113', '[10]', null, null, '0'), ('32', 'RoleFunctions', '10', '[210][225][211][241][32][33][199][242][38][41][200][201][239][202][40][232][233][197][44][203][204][205][206][212][246][207][208][209][226][227][228][229][59][235][237][244][22][21][23][220][240][247][25][24][217][218][26][194][195][31][13][14][243][15][234][248][198][260][261]', '[{\"funId\":13,\"btnStr\":\"1\"},{\"funId\":14,\"btnStr\":\"1\"},{\"funId\":243,\"btnStr\":\"1\"},{\"funId\":234,\"btnStr\":\"1\"},{\"funId\":22,\"btnStr\":\"1\"},{\"funId\":23,\"btnStr\":\"1\"},{\"funId\":220,\"btnStr\":\"1\"},{\"funId\":240,\"btnStr\":\"1\"},{\"funId\":247,\"btnStr\":\"1\"},{\"funId\":25,\"btnStr\":\"1\"},{\"funId\":217,\"btnStr\":\"1\"},{\"funId\":218,\"btnStr\":\"1\"},{\"funId\":26,\"btnStr\":\"1\"},{\"funId\":194,\"btnStr\":\"1\"},{\"funId\":195,\"btnStr\":\"1\"},{\"funId\":31,\"btnStr\":\"1\"},{\"funId\":241,\"btnStr\":\"1,2,7\"},{\"funId\":33,\"btnStr\":\"1,2,7\"},{\"funId\":199,\"btnStr\":\"1,7,2\"},{\"funId\":242,\"btnStr\":\"1,2,7\"},{\"funId\":41,\"btnStr\":\"1,2,7\"},{\"funId\":200,\"btnStr\":\"1,2,7\"},{\"funId\":210,\"btnStr\":\"1,2,7\"},{\"funId\":211,\"btnStr\":\"1,2,7\"},{\"funId\":197,\"btnStr\":\"1,2,7\"},{\"funId\":203,\"btnStr\":\"1,7,2\"},{\"funId\":204,\"btnStr\":\"1,7,2\"},{\"funId\":205,\"btnStr\":\"1,2,7\"},{\"funId\":206,\"btnStr\":\"1,7,2\"},{\"funId\":212,\"btnStr\":\"1,2,7\"},{\"funId\":201,\"btnStr\":\"1,2,7\"},{\"funId\":202,\"btnStr\":\"1,2,7\"},{\"funId\":40,\"btnStr\":\"1,2,7\"},{\"funId\":232,\"btnStr\":\"1,2,7\"},{\"funId\":233,\"btnStr\":\"1,2,7\"},{\"funId\":261,\"btnStr\":\"1\"}]', null, '0'), ('34', 'UserRole', '115', '[10]', null, null, '0'), ('35', 'UserRole', '117', '[10]', null, null, '0'), ('36', 'UserDepot', '117', '[8][9]', null, null, '0'), ('37', 'UserCustomer', '117', '[52]', null, null, '0'), ('38', 'UserRole', '120', '[4]', null, null, '0'), ('41', 'RoleFunctions', '12', '', null, null, '0'), ('48', 'RoleFunctions', '13', '[59][207][208][209][226][227][228][229][235][237][210][211][241][33][199][242][41][200]', null, null, '0'), ('51', 'UserRole', '74', '[10]', null, null, '0'), ('52', 'UserDepot', '121', '[13]', null, null, '0'), ('54', 'UserDepot', '115', '[13]', null, null, '0'), ('56', 'UserCustomer', '115', '[56]', null, null, '0'), ('57', 'UserCustomer', '121', '[56]', null, null, '0'), ('67', 'UserRole', '131', '[17]', null, '63', '0'), ('68', 'RoleFunctions', '16', '[210]', null, '63', '0'), ('69', 'RoleFunctions', '17', '[242][38][41][200][217][235][209]', '[{\"funId\":217,\"btnStr\":\"1,2,7\"},{\"funId\":242,\"btnStr\":\"1,2,7\"},{\"funId\":41,\"btnStr\":\"1,2,7\"},{\"funId\":200,\"btnStr\":\"7,2,1\"}]', '63', '0'), ('83', 'RoleFunctions', '21', '[241][33][246][208][226][227][228][229][22][21][23][220][247][25]', '[{\"funId\":22,\"btnStr\":\"1\"},{\"funId\":23,\"btnStr\":\"1\"},{\"funId\":220,\"btnStr\":\"1\"},{\"funId\":247,\"btnStr\":\"1\"},{\"funId\":25,\"btnStr\":\"1\"},{\"funId\":241,\"btnStr\":\"2,1,7\"},{\"funId\":33,\"btnStr\":\"2,1,7\"}]', '63', '0'), ('84', 'UserRole', '146', '[21]', null, '63', '0'), ('85', 'RoleFunctions', '22', '[201][202][232][233][246][226][227][228][229][261][260][26][41][200]', '[{\"funId\":26,\"btnStr\":\"1\"},{\"funId\":41,\"btnStr\":\"1,2,7\"},{\"funId\":200,\"btnStr\":\"1,2,7\"},{\"funId\":201,\"btnStr\":\"1,2,7\"},{\"funId\":202,\"btnStr\":\"1,2,7\"},{\"funId\":232,\"btnStr\":\"1,2,7\"},{\"funId\":233,\"btnStr\":\"1,2,7\"},{\"funId\":261,\"btnStr\":\"1\"}]', '63', '0'), ('86', 'UserRole', '147', '[22]', null, '63', '0'), ('87', 'UserRole', '148', '[17]', null, '63', '0'), ('88', 'RoleFunctions', '23', '[260][261][21][22][23][220][247][226][227][246][229][228]', '[{\"funId\":22,\"btnStr\":\"1\"},{\"funId\":23,\"btnStr\":\"1\"},{\"funId\":220,\"btnStr\":\"1\"},{\"funId\":247,\"btnStr\":\"1\"},{\"funId\":261,\"btnStr\":\"1\"}]', '63', '0'), ('89', 'UserRole', '149', '[23]', null, '63', '0');
COMMIT;

-- ----------------------------
--  Table structure for `tbl_sequence`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_sequence`;
CREATE TABLE `tbl_sequence` (
  `seq_name` varchar(50) NOT NULL COMMENT '序列名称',
  `min_value` bigint(20) NOT NULL COMMENT '最小值',
  `max_value` bigint(20) NOT NULL COMMENT '最大值',
  `current_val` bigint(20) NOT NULL COMMENT '当前值',
  `increment_val` int(11) NOT NULL DEFAULT '1' COMMENT '增长步数',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`seq_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='sequence表';

-- ----------------------------
--  Records of `tbl_sequence`
-- ----------------------------
BEGIN;
INSERT INTO `tbl_sequence` VALUES ('depot_number_seq', '1', '999999999999999999', '1', '1', '单据编号sequence');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
